Browse by Tags

TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)

Published 4 September 7 9:32 AM | SSQA.net

PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query...

Filed under: sql server, stats, performance, blocking, tuning, query, stored procedure, statistics, parallelism, contribution

How to check performance difference between 2 identical SQL Servers?

Published 5 July 7 10:6 AM | SSQA.net

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

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

Get backup and restore performance stats with a DMV

Published 12 June 7 8:25 AM | SSQA.net

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

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

Get statistics on Query plan optimizer execution

Published 11 May 7 4:48 AM | SqlServer-QA.net (SSQA)

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

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

Stored procedures performance issues

Published 8 May 7 5:57 AM | SqlServer-QA.net (SSQA)

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

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