SqlServer-QA.net

PERFMON and Resource Governor - two great tools in hand for a DBA to monitor/resolve the performance problems, agreee! Back in olden days you may remember about SQLDiag and PSSDiag, the utility used as a general purpose diagnostics collection utility that can be run as a console application or as a service. Both of these Diag tools are helpful to ...

I was working with one of the user project to monitor the Performance Audit of their SQL Server estate. One SQL instance among the SQL farm is very important to their day-to-day business and cannot sustain even 5 minutes of downtime which is termed as 24/7 kind of application. During the troubleshooting exercise I have noticed a peculiar issue ...

Recently  I was involved in one of the Performance Audit exercise at a client's place where they complain about Server CPU is always HIGH and what they have observed is even the physical disk where TEMPDB is located has been used extensively, as they can see spikes from SYSMON counters. So whenever a performance problem arises (SQL ...

Performance - one word does it all!  You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services (BI) database then no difference as one of the greatest enhancements in Analysis ...

As you are aware that SYSMON (PERFMON) provides very useful counters to analyze the system performance or to schedule a historical growth of your system usage.   From the changes (upgrade) to the Operating System and  SQL Server we now have new set of SQL Server Integration Services ...

One of the best features you have in the SQL Server is to create database data file (additional) on fly without  having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that is used for the databases and how big disk queue length in terms of I/O ...

Performance tuning exercise involves using SYSMON for the server based tasks,  also I have seen users referring that MEMORY is at peak level by referring to Task Manager on the server. Not always depend upon the task manager, for optimum information better to rely upon SYSMON counters. In this scenario capturing the Available Byes & ...

As you may aware the PERFMON (SYSMON) utility provides much information to analyze on the systems resource usage, I support and suggest to make use of this tool as much as you can with a default templates within our environment. You may be aware the data is saved as a file with .BLG extension which can be opened again using this SYSMON tool. I ...

If a particular query is performing poorly the first thing you would check is relevant indexes, even though having associated indexes against those tables may not help any better to the performance. The next phase you observe is high CPU count from the Task Manager (TM), up to some extent using TM is useful but never come into conclusion that ...