System Monitor counters for SQL Server reflect sum of all instances?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steveraden@yahoo.com - 26 Mar 2008 02:50 GMT

Hello, I wanted to confirm tht there are no issues when you have a
perf mon counter object such as SQL Server Buffer Manager and your
host machine has mutliple SQL Server instances running. That is the
counters simply reflect the sum of the values for all instances.
Thank you.

Reply to this Message

Linchi Shea - 26 Mar 2008 03:39 GMT

No, each SQL instance has its own set of perfmon objects, including Buffer
Manager. If you scroll up and down the list, you would see them unless there
is a problem with the perfmon counter installation.

Note that buffer pool management is particular to each SQL instance. For
most of the buffer manager counters (e.g. page life expectancy), it doesn't
make any sense to sum their values up.

Linchi

> Hello, I wanted to confirm tht there are no issues when you have a
> perf mon counter object such as SQL Server Buffer Manager and your
> host machine has mutliple SQL Server instances running. That is the
> counters simply reflect the sum of the values for all instances.
> Thank you.

Reply to this Message