In the following sections, we will talk briefly about sp_who and sp_who2 stored procedure, then we will illustrate Monitoring and analysis process, also they show much useless information (system processes).įor this reason, Adam Machanic (a Microsoft MVP since 2004) developed a more powerful stored procedure called “ sp_whoisactive” to fill in the gap between the actual needs of DBAs and theĬurrently provided procedures (sp_who and sp_who2). Running processes on the instance but they lack much useful information that can facilitate the performance In general, Microsoft provided two system stored procedures called “sp_who” and “sp_who2” to retrieve all currently In this article, we will talk about sp_WhoIsActive stored procedure and how we can use it to monitor currentlyĭatabase administrators (DBAs) are incessantly checking currently running operations over an SQL Server instance especially when the server is slowing down.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |