Browse by Tags

All Tags » profiler » performance   (RSS)
Table fragmentation, Index contention and locking issues to resolve
31 July 07 07:31 AM | SQL Master | 2 Comments   
Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to Read More...
SQL Server 2005 high CPU occurrence - why it is?
18 June 07 07:33 AM | SQL Master | 2 Comments   
If a particular query is performing poorly the first thing you would check is relevant indexes, even though having associated indexes against those tables may not help any better to the performance. The next phase you observe is high CPU count from the Read More...
Identify and troubleshoot slow running queries in SQL Server
25 May 07 04:53 AM | SQL Master | 4 Comments   
Achieving the performance for slow running queries is not a rocket science to understand. The database performance is dependant on implementing optimum database design with sensible hardware-based configuration and capacity planning. So how you can identify Read More...
Stored procedures performance issues
08 May 07 03:57 AM | SQL Master | 0 Comments   
Every now and then I tend to see lot of questions such as "We have a web application which interacts with SQL Server through Stored Procs. Every so often it seems the response time for an individual Stored Proc will go from a few seconds to a few minutes. Read More...

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication