Top 10 Tips for Optimizing SQL Server Performance

By: Edgewood Solutions | Read Comments (1) | Print Edgewood Solutions is a technology company focused on Microsoft SQL Server and founder of MSSQLTips.com. Related Tips: More

Top 10 Tips for Optimizing SQL Server Performance

SQL Server performance management requires serious time and energy. In this new white paper by Kevin Kline, discover detailed guidance on the issues you can relate to—from cache trashing to bad T-SQL that can return to haunt your applications. See how to maximize database scalability and efficiency with ease. Read the white paper today.

Read this new whitepaper!

Related Tips: More | Become a paid author

Last Update: 8/29/2011

Share:

Share

Tweet

Free SQL Server Learning Free webcast - Introduction to SQL Azure Demystify TempDB Performance and Manageability

Comments and Feedback:

Tuesday, February 28, 2012 - 3:38:32 AM - Sateesh	Read The Tip
Hello Team, here i am facing some hard time  with SQL SERVER performance, sometimes  DB is responding very quickly that is like fraction of seconds but some times same query and same amount of data that is taking around 5 sec . i have indexes on the table and for DB i have create and update statics on. Please tell me what might be the problem. Thanks in advance! Sateesh

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

"SQL diagnostic manager delivers response in minutes, not hours!" It takes just 5 minutes to connect your SQL Databases to source control. Got 5 minutes? Get started now. SQL Servers keeping you up at night? Contact the Edgewood SQL Server DBAs for a Health Check. Prices start at $995. Find and Fix SQL issues with Foglight Performance Analysis. Get a free copy. Join the over million SQL Server Professionals who get their issues resolved daily. Demystify TempDB Performance and Manageability