SqlServer-QA.net

A common scenario in SQL Server environment that often application users complained about slow performance and same time you observe high CPU usage/spikes on the SQL Server instance, so better to follow the methods from HighCPU-whyitis blog and still you have not seen no sign of resolution to the problem, go down this blog. Back to basics, ...

PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query is slow when it is using a parallel plan, you can try forcing a non-parallel plan by ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New and Major Modifications FIX: Performance is very slow when the same stored procedure is executed at the same time in many ...

This was the question asked by a Developer when we are investigating a performance loss issues on a database. To the point a derived table means a virtual table that's calculated on the fly from a select statement. By default using derived tables can be tremendously useful in certain situations. In any case if you have 2 queries in hand say one ...

If you ask an experience DBA about the reasons for performance loss then the answer should be straight to look for SQL Server, Operating System and hardware counters for further investigation. Simultaneous access to shared resources causes bottlenecks. In general, bottlenecks are present in every software system and are ...

Is it possible to get statistics like how many times a stored procedure is called such as average execution time and how often that procedure is being called. Bascially it is possible to get provided that particular stored procedure is active and plan is available in the cache. Using a DMV sys.dm_exec_query_stats that will give the execution ...

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 Task Manager (TM), up to some extent using TM is useful but never come into conclusion that ...