Browse by Tags

• analysis
• backups
• blocking
• blogs
• cache
• databases
• disk
• disks
• dmv
• execution plan
• FAQ
• force
• guide
• high cpu
• i/o
• index
• IO
• kba
• memory
• optimization
• parallel execution
• partition
• query
• request
• resources
• sql server
• ssms
• subsystem
• taking longer

Considering Parallel plans and forcing plans for better performance
23 October 07 06:55 AM | SQL Master | 2 Comments   

Parameterizing T-SQL queries are a well-known task such as database programming and best practice in some tasks. It allows query plan reuse and eliminates the need of recompilation for multiple invocations of the same query that simply has different parameter Read More...

Filed under: performance, sql server, cache, optimization, cpu, index, partition, parallel execution, force, guide

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

sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!
17 August 07 06:04 AM | SQL Master | 3 Comments   

The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any Read More...

Filed under: ssms, performance, sql server, dmv, memory, cpu, disks, analysis

List of CPU based DMVs in SQL Server 2005 - best used for hardware analysis
05 August 07 12:32 PM | SQL Master | 5 Comments   

Dynamic Management Views (DMV) are very useful to get server state information to monitor the status, but not always you have to still continue in monitoring using SYSMON & PROFILER that are available by default with SQL installation. The engine within Read More...

Filed under: performance, sql server, cache, dmv, cpu, i/o

SQL Server has encountered % occurrence(s) of IO requests taking longer than 15 seconds to complete on file
13 July 07 03:25 AM | SQL Master | 1 Comments   

By now you should have applied the Service Pack 4 on your SQL Server 2000 instances and you might come across the message within the SQL error log " SQL Server has encountered 5877 occurrence(s) of IO requests taking longer than 15 seconds to complete Read More...

Filed under: performance, sql server, memory, disk, cpu, taking longer, IO, subsystem, request