Browse by Tags

SQL Server High Number of User Connections found on PERFMON, how to resolve it?

Published 3 June 8 3:7 AM | SSQA.net

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

Filed under: sql server, performance, sysmon, 2000, 2005, high cpu, perflib, activity, user connections, mars

SQL Server 2005 PERFMON counter spikes in Transactions/sec and Buffer Cache Hit ratio, what does it say?

Published 14 March 8 4:16 AM | SSQA.net

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

Filed under: sql server, perfmon, performance, dmv, cache, buffer, sysmon, tempdb, monitoring, temp tables, worktables, workfiles, ratio

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

Published 18 February 8 3:57 AM | SSQA.net

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

Filed under: sql server, profiler, performance, databases, security, process, sysmon, administrator, Analysis Services, diagnose

SYSMON (PERFMON) counters that will help you to resolve SQL Server Integration Services issue

Published 31 January 8 3:45 AM | SSQA.net

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

Filed under: sql server, performance, ssis, users, best practices, sysmon, perflib, data flow, integration services

How SQL Server manages when a database is created in terms of I/O and disk usage?

Published 29 January 8 5:46 AM | SSQA.net

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

Filed under: sql server, performance, management, indexes, windows, i/o, sysmon, disk space, usage, resource, perflib, worker threads, task manager

Paging and Available Memory for Operating sysem, what you need to know?

Published 6 September 7 7:29 AM | SSQA.net

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

Filed under: sql server, performance, microsoft, server, sysmon, paging, vmm, processes, virtual memory

How to Analyze the PERFMON (SYSMON) data?

Published 20 August 7 1:26 PM | SSQA.net

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

Filed under: sql server, perfmon, performance, analysis, databases, tuning, sysmon, tsql