Activity monitor unable to execute queries againest the server?

Question

2012 SQL Serevr SSMS

Activity monitor unable to execute queries againest the server?

any ideas???

---

ebro

Answer 1

There is a Connect item related to the issue:

https://connect.microsoft.com/SQLServer/feedback/details/776611/the-activity-monitor-is-unable-to-execute-queries-against-server-xyz

Are you up-to-date with service packs?

Blog: http://sqlsailor.com/2013/05/02/actmonissue/

---

Kalman Toth Database & OLAP Architect Free T-SQL Scripts
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012

Answer 2

Are you connecting to same version or any other version from SQL 2008/2005?

Refer the below link

http://sqlsailor.com/2013/05/02/actmonissue/

-Prashanth

Answer 3

It was working good for a long time and it is a sudden failure. Is it still a "connect" issue?

And here is the select @@Version result

Microsoft SQL Server 2012 - 11.0.2100.60 (X64) 
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Standard Edition (64-bit)
on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Thanks in Advance

---

ebro

Answer 4

same version

---

ebro

Answer 5

Hi,

Please check if there are useful message in SQL error log. If there is lock the memory message was logged in the error log, you may enable lock pages in memory option for the SQL Server service account and see how it works.

Also, apply the service pack and updates of SQL Server.

To enable the lock pages in memory option, please see:

Enable the Lock Pages in Memory Option (Windows)

http://msdn.microsoft.com/en-us/library/ms190730.aspx

Thanks.

---

Tracy Cai
TechNet Community Support