Browse by Tags

• backups
• blog
• blogs
• buffer
• cpu
• dirty
• dmv
• execution plan
• FAQ
• high cpu
• indexes
• kba
• memory
• monitor
• performance
• query
• resources
• sql server

High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!
20 September 07 08:40 AM | SQL Master | 2 Comments   

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations, Read More...

Filed under: performance, sql server, query, blocking, databases, cpu, kba, execution plan, high cpu, resources, FAQ, blogs, backups

How to find dirty buffer pages and clear them - SQL Server
21 May 07 08:22 AM | SQL Master | 0 Comments   

Dirty buffer pages are nothing but consuming more memory for even smaller queries on the SQL Server. By default the DBA shouldn't worry about these dirty pages in the buffer pool as they are taken care by the system using Write Ahead Logging ( WAL )method. Read More...

Filed under: sql server, dmv, blocking, memory, databases, buffer, dirty

SQL Server 2005 how to find a rarely used index?
18 May 07 03:31 AM | SQL Master | 1 Comments   

For a SQL Server database having an index is always beneficial and from performance point of view too. But how about the clustered index which is occupying space on the database that is not used by any of the queries in the database. The Query Optimizer Read More...

Filed under: databases, sql server, blocking, indexes, perfmance, blog, monitor