Browse by Tags

• backup
• databases
• dmv
• identify
• indexes
• optimization
• package
• perfmon
• performance
• profiler
• query
• read
• reporting
• restore
• security
• server
• sql server
• storage
• troubleshoot
• wait

How to check performance difference between 2 identical SQL Servers?
05 July 07 08:06 AM | SQL Master | 1 Comments   

Say you have two identical SQL Servers with similar databases in two different branches. Only the database sizes differ by about 20% and server machine are also identical. You will get a complaint that the performance of one is very very low compare to Read More...

Filed under: performance, sql server, server, query, stats

Get backup and restore performance stats with a DMV
12 June 07 06:25 AM | SQL Master | 2 Comments   

Normally the backup and restore operation will be quick enough or depends upon the server configuration to complete. Say if you have started with a 2GB size of database and over the time as that database is updated, the amount of data that is included Read More...

Filed under: performance, sql server, stats, dmv, read, backup, restore

Identify and troubleshoot slow running queries in SQL Server
25 May 07 04:53 AM | SQL Master | 4 Comments   

Achieving the performance for slow running queries is not a rocket science to understand. The database performance is dependant on implementing optimum database design with sensible hardware-based configuration and capacity planning. So how you can identify Read More...

Filed under: performance, stats, indexes, profiler, databases, storage, identify, troubleshoot

Get statistics on Query plan optimizer execution
11 May 07 02:48 AM | SQL Master | 2 Comments   

As you might know PERFMON (SYSMON) and DMVs in SQL 2005 are very handy to know internal resource information about the SQL Server engine. So you might be thinking what might be the cause of this poor performance when you have a simple query to run and Read More...

Filed under: reporting, sql server, security, query, stats, optimization, perfmance

Stored procedures performance issues
08 May 07 03:57 AM | SQL Master | 0 Comments   

Every now and then I tend to see lot of questions such as "We have a web application which interacts with SQL Server through Stored Procs. Every so often it seems the response time for an individual Stored Proc will go from a few seconds to a few minutes. Read More...

Filed under: performance, sql server, stats, package, perfmon, profiler

High CPU spikes affecting performance
26 April 07 01:59 PM | SQL Master | 2 Comments   

I have seen a common question across the forums & newsgroups that CPU is 100% when we are running a query on SQL Server. So it is important to understand whether CPU is affecting or is it a bad query that is affecting SQL Server performance in spite Read More...

Filed under: performance, sql server, security, server, stats, wait