geek sync i sql server tuning without touching t-sql
Post on 13-Apr-2017
573 Views
Preview:
TRANSCRIPT
SQL Server Tuning Without Touching T-SQL
Pinal Dave
Agenda
Statistics
Disk SpeedDatabase File Setup
Resources3
12
4
1
Let’s Start with the Basics
fundamentals of databaseSQL Server
MDF/NDF contains Data
LDFcontains Log
Almost Everything – Tables, Index, Stored Procedures, Views, Jobs, Triggers, Logins, Constrains, Security Information, System Databases
Rollback information for databaseNO Real Data
FastSlow
\Demo 1\
INSERT SELECT
Data On FasterLog on Faster
Data On FasterLog on Slower
Data On SlowerLog on Faster
Pre-Size Database Files
Initializing the new space is a BLOCKING operation
Pre-sizing Database Sizeminimizes new space initializing
Fixed Autogrowth Value
\Demo 2\
database setting
What is the BEST practice forAuto Create Statistics Auto Update Statistics ?
\Demo 3\
http://bit.ly/sqlnow
Resources
www.idera.com
Try Any of Our Tools Free!
top related