Browse by Tags

• blogs
• cache
• compiled
• compression
• dmv
• high cpu
• impact
• indexed views
• indexes
• joins
• kba
• memory
• profiler
• query
• recompile
• sql server
• sysmon
• times
• too many
• tuning

Stored Procedures caught me with too many recomplies - way out to avoid it
25 October 07 01:35 AM | SQL Master | 2 Comments   

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

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

Performance Tuning - will I loss the indexing when using derived table?
21 August 07 01:19 AM | SQL Master | 2 Comments   

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

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

Knowing about performance impact of simple use of procedures
13 July 07 07:42 AM | SQL Master | 1 Comments   

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

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

SQL Server 2005: Stored Procedure call activity statistics & execution time
21 June 07 02:56 PM | SQL Master | 1 Comments   

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

Filed under: stored procedure, times, compiled, performance, cache, memory

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

Filed under: performance, profiler, sysmon, recompile, stored procedure