Browse by Tags

• best practice
• high cpu
• kba
• links
• msdn
• performance
• performance monitoring
• rebuild
• recompile
• reorganize
• schedule
• schema
• sql server
• stored procedure
• too many

SQL Server indexing - when to reorganize or rebuild?
21 January 08 03:30 AM | SQL Master | 4 Comments   

Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts Read More...

Filed under: sql server, indexes, msdn, rebuild, schema, best practice, blogs, performance monitoring, reorganize, links, schedule

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