Microsoft SQL Server Performance Data Collection Strategies. Date. What about Bill?. Follow me on Twitter @ BillRamo. 39 24 22 15 6 4. About Advaiya. Frustrated trying to justify resources? Interested in migrating Oracle, MySQL, Sybase, Access to SQL Server?
Microsoft SQL Server Performance Data Collection Strategies
Follow me on Twitter @BillRamo
39 24 22 15 6 4
Easily go back in time to see trends.
Perform and extend tasks based on instance problem
Setup Metrics that you care about.
Plan UI shows missing index with expected impact
Use parameter substitution UI to name the index, remove the comments, run the command and the problem is solved
Click on big stuff to see query details
Click on the big stuff again to see query plan details
Query optimizer recommends a missing index so click on View Plan link
Missing Index Details command loads index statement in editor for DBA to decide
Click on SQL Server CPU line to see queries
Obvious query causing the CPU problem
Index created here
Expected range before ending workload
MDW grows around 250GB to 600 GB per day per instance collected compared to Ops Manager DB which has collects much less data