Browse by Tags

Stored Procedures caught me with too many recomplies - way out to avoid it

Published 25 October 7 3:35 AM | SSQA.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...

Filed under: sql server, performance, indexes, blogs, kba, stored procedure, high cpu, recompile, too many

TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)

Published 4 September 7 9:32 AM | SSQA.net

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...

Filed under: sql server, stats, performance, blocking, tuning, query, stored procedure, statistics, parallelism, contribution

FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005

Published 23 August 7 6:29 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, performance, kba, connections, stored procedure, slow, multi-processor

Performance Tuning - will I loss the indexing when using derived table?

Published 21 August 7 3:19 AM | SSQA.net

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...

Filed under: sql server, performance, tuning, query, stored procedure, joins, indexed views

Knowing about performance impact of simple use of procedures

Published 13 July 7 9:42 AM | SSQA.net

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...

Filed under: sql server, performance, dmv, compiled, impact, stored procedure, compression