I have two instances of SQL Server running on my laptop, one is SQL Server 2008 and the other is SQL Server 2008 R2. Now take a look at this image from task manager.
Can you tell which process is the 2008 instance and which process is the 2008 R2 instance? I can’t either. Now if you want to know what process id your instance is using you can do three things
1) Use T-SQL
Run the following query in a query window
select SERVERPROPERTY('processid'),SERVERPROPERTY('productversion')
I get the following as output when running that query on both instances
2212 10.0.2531.0 2184 10.50.1600.1
So, now I know that the 2008 instance is using processid 2212 and the 2008 R2 instance is using 2184
2) Look at the SQL Server log
If I look at my SQL Server log, I see the following
05/12/2010 08:24:25,System Manufacturer: ‘Hewlett-Packard’
05/12/2010 08:24:25,Server process ID is 2184.
05/12/2010 08:24:25,All rights reserved.
05/12/2010 08:24:25,© Microsoft Corporation.
05/12/2010 08:24:25,Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 (X64)
3) Use the services tab in task manager
This is probably the easiest one, just switch to the services tab
*** Remember, if you have a SQL related question, try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
