1

I just asked about performance monitor VS 2015 and got perfect answer. I wish there could be performance monitor available for SQL Server Management Studio also. Is it available for any version of SQL Server Management Studio? If yes where is it?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Leena
  • 35
  • 3

1 Answers1

1

For SQL Server 2014 inside "Object Explorer" right click on the root node (your SQL Server instance) and select "Activity Monitor" from the menu:

enter image description here

or use the shortcut CTRL + ALT + A

or click the highlighted button in the toolbar:

enter image description here

More information here on Microsoft docs.

Andrea
  • 11,801
  • 17
  • 65
  • 72
  • Thanks ...one very basic question ....please tell me , this activity overview is for every database object or just for queries and stored procedures? – Leena Jul 19 '17 at 14:50