June 4, 2008 at 1:32 pm
Hello, I am looking for a good SQL Server 2000/2005/2008 white paper on a methodology for monitoring and tuning databases. Any links would be greatly appreciated. Thank you.
-David
Best Regards,
~David
June 4, 2008 at 8:10 pm
Here are a few:
Uncover Hidden Data to Optimize Application Performance
http://msdn.microsoft.com/en-us/magazine/cc135978.aspx
Troubleshooting Performance Problems in SQL Server 2005: http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx#EUVAE
SQL Server 2005 Performance Tuning using Waits and Queues:
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx
Making Sense of your SQL Server Application’s Performance – A Practical Guide
http://www.sswug.org/whitepapers/papers/WP_MakingSenseSS_final_1.pdf
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 5, 2008 at 6:39 am
I love that article from MS on tuning using WAIT states. It's great.
Here's a simple article that might help.
http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/[/url]
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 5, 2008 at 7:00 am
Excellent! Thank you guys!!!
-David
Best Regards,
~David
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply