One that I often use this view for is to look for blocking issues. They start as All.įor a simple example of using this though, we could pick sessions that have any type of command running, by choosing Task State of RUNNING. They show you a list of values currently in that column, plus an All, and a choice of Blanks (rows with no value in this column) or NonBlanks (rows with anything in this column). You can also kill the process (obviously carefully), and you can connect SQL Server Profiler to the server and filter the session immediately, to see what it's doing. Take note that this doesn't mean it's still running. The Details link will show you the last command executed on that connection. If you right-click any session, you get these options: The list of Processes is more interesting. It will show you if the server is running flat out. I don't find most of the graphs at the top very useful, apart from perhaps the processor time. I've been to sites where there are many copies of it running all the time from several users. However, please don't leave it running and go on using other tabs. Note that if you connect to more than one server in Object Explorer, Activity Monitor will connect to whichever one you have selected any object from within.Īctivity Monitor puts a bit of a load on the server that it's connected to but I generally don't find it too bad. The other common way to launch it is from the Toolbar: The first is to right-click the server in Object Explorer: There are two basic ways to launch Activity Monitor. While there are many clever things that we can do with queries, to interrogate the health of the system, don't forget that there is quite a bit of useful information in Activity Monitor, and it's easy to get to. I see many people using SQL Server Management Studio (SSMS) and they aren't aware of Activity Monitor. This is a quick tip but an important one.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |