February 23, 2017 at 10:11 am
I have 3 sql instances installed on a server and customer is complaining high cpu and memory utilisation .How can we check on which instance having the issue ?
February 23, 2017 at 11:00 am
ramyours2003 - Thursday, February 23, 2017 10:11 AMI have 3 sql instances installed on a server and customer is complaining high cpu and memory utilisation .How can we check on which instance having the issue ?
Not sure if you are trying to find this as the OS level or if you are trying to find issues in an instance. Not sure how a customer would know about cpu or memory use for one of the instances either but...
If you are trying to find issues for an instance, you could start with running diagnostic queries on the instances. Glenn Berry has a great set of these for different SQL Server versions. Here is a link to the latest set:
SQL Server Diagnostic Information Queries for February 2017
If you are trying to find which instance is which at the OS level, all of them have a process ID (PID) that you can get from Task Manager as well as cpu and memory use. You can get the PID for an instance with:
SELECT SERVERPROPERTY('ProcessID')
Sue
February 24, 2017 at 5:09 am
Sue_H - Thursday, February 23, 2017 11:00 AMramyours2003 - Thursday, February 23, 2017 10:11 AMI have 3 sql instances installed on a server and customer is complaining high cpu and memory utilisation .How can we check on which instance having the issue ?Not sure if you are trying to find this as the OS level or if you are trying to find issues in an instance. Not sure how a customer would know about cpu or memory use for one of the instances either but...
If you are trying to find issues for an instance, you could start with running diagnostic queries on the instances. Glenn Berry has a great set of these for different SQL Server versions. Here is a link to the latest set:
SQL Server Diagnostic Information Queries for February 2017If you are trying to find which instance is which at the OS level, all of them have a process ID (PID) that you can get from Task Manager as well as cpu and memory use. You can get the PID for an instance with:
SELECT SERVERPROPERTY('ProcessID')Sue
The process id is also shown in sql server configuration manager
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply