patternsqlMinor
This instance of (MS) SQL Server has been using a process id of X since dd/mm/yyyy
Viewed 0 times
thisprocesssqlyyyybeensinceinstancehasusingserver
Problem
I was looking through the SQL Server logs and come across the following informational message.
This instance of SQL Server has been using a process ID of 1960 since 12/10/2014 20:02:48 (UTC). This is an information message only: no user action is required.
This message has been generated for the last three days. I cannot see the process-id using the activity monitor.
Is this something that may cause/highlight a problem that I need to look into?
This instance of SQL Server has been using a process ID of 1960 since 12/10/2014 20:02:48 (UTC). This is an information message only: no user action is required.
This message has been generated for the last three days. I cannot see the process-id using the activity monitor.
Is this something that may cause/highlight a problem that I need to look into?
Solution
No, this is perfectly normal, as the message says. It is just SQL Server's way of telling you the pid.
To verify, within SQL Server you can do
To verify, within SQL Server you can do
select serverproperty('processid'), and then in the OS space you should be able to check the process ID like this in a one-liner PowerShell command:Get-Process "sqlservr"Code Snippets
Get-Process "sqlservr"Context
StackExchange Database Administrators Q#82824, answer score: 7
Revisions (0)
No revisions yet.