Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Performance Tuning, SQL Server Rss

   Items 1 to 3 of 3   

Fundamentals of Storage Systems – Capturing IO Patterns

We often take the advice given to us on forums or in articles at face value. Even though the authors...  Read more...
By Wesley Brown 2009/11/27 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,835 reads

SQL Server Legend – Data Files and Threads

Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...  Read more...
By Steve Jones 2009/10/20 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,273 reads

Finding the Causes of Poor Performance in SQL Server, Part 1

To tackle performance problems with applications, first use SQL Profiler to find the queries that constitute a typical workload: From the trace, spot the queries or stored procedures that are having the most impact. Then it's down to examining the execution plans and query statistics. You then see what effects you've had and maybe repeat the process. Gail explains all, in a two-part article.  Read more...
By Additional Articles 2009/03/23 | Source: SimpleTalk | Category: performance tuning
Rating:  Rate this |   Briefcase | 5,122 reads
   Items 1 to 3 of 3   
blogs (2)    
fundamentals (1)    
io (1)    
query performance (1)    
sql server 2005 (1)    
storage (1)    
tools (1)