How to get the process id of SQL Server

Hi Friends,

There may be a situation when you may want to know the process id of your SQL Server Process. You can get this information from various methods. Here I’ll show you two basic methods.

  • Using Task Manager: this method can be used, if you are on the same server on which that process is running. Steps are mention below:

1-      Click Ctrl + Alt + Delete
2-      Click on Start Task Manager, this will open windows task manager
3-      Click on Services Tab.
4-      Here you can find out the service along with PID (Process Id)
5-       Note down this process id

SQL_Server_Process_ID_1

  • Using SQL Server Error Log: This method can be useful, if you are not on that Server where that process is running. Most of the times we connect the SQL Server from management studio on our local system. Open a new query window and ran the below command
exec xp_readerrorlog

From output you can easily find out the process id of your SQL Server Process.

SQL_Server_Process_ID_2

HAPPY LEARNING!

Regards:
Prince Kumar Rastogi

Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook

Follow Prince Rastogi on Twitter | Follow Prince Rastogi on FaceBook

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Avatar

About Prince Rastogi

Prince Rastogi is working as Database Administrator at Elephant Insurance, Richmond. He is having more than 8 years of experience and worked in ERP Domain, Wealth Management Domain. Currently he is working in Insurance domain. In the starting of his career he was working on SQL Server, Internet Information Server and Visual Source Safe. He is post graduate in Computer Science. Prince is ITIL certified professional. Prince likes to explore technical things for Database World and Writing Blogs. He is Technical Editor and Blogger at SQLServerGeeks.com. He is a regular speaker at DataPlatformDay events in Delhi NCR. He has also presented some in depth sessions about SQL Server in SQL Server Conferences in Bangalore.

View all posts by Prince Rastogi →

Leave a Reply

Your email address will not be published. Required fields are marked *