diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


SQL Server 2008 Activity Monitor

The Activity Monitor node is no longer under the Management Folder in SSMS,” Ramos explained. “Instead, we’ve added a new icon on the main toolbar at the far right side. We also added the Activity Monitor command to the Server context menu as well. Although I don’t show it, you can also configure SSMS to start-up with Activity Monitor using the Tools | Options command.

Unlike the previous version of the Activity Monitor (AM), the new AM starts up with a 10 second refresh interval. That doesn’t necessarily mean that each of the four panes: Overview, Processes, Resource Waits, Data File I/O, and Recent Expensive Queries all refresh at the specified interval, Ramos stated.

Source:→ Softpedia

Share This Story, Choose Your Platform!

Do NOT follow this link or you will be banned from the site!