Unable to launch Activity Monitor

Question

Unable to launch Activity Monitor

Les Sprott

Mr or Mrs. 500

Points: 567
More actions
April 23, 2008 at 3:05 pm

#154297

The link to the knowledge base says there is nothing on this message. Has anyone experienced the same problem?
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Unable to execute requested command.
------------------------------
Unable to launch Activity Monitor. You may not have sufficient permissions. (ActivityMonitor)
------------------------------
View or function 'master.sys.dm_exec_sessions' has more column names specified than columns defined. (Microsoft SQL Server, Error: 4502)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=4502&LinkId=20476

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Ziljan4 Ten Centuries Points: 1136 More actions · Answer 1

Probably you might have too many SQL connections, and it has been able to load all the connections, so it is timing out.

try SP_who2 gives you same information.

jezemine SSCrazy Eights Points: 8059 More actions · Answer 2

this should give you a hint:

"View or function 'master.sys.dm_exec_sessions' has more column names specified than columns defined. (Microsoft SQL Server, Error: 4502)"

it means the client tool (in this case activity monitor) is expecting the view to have certain columns that don't exist on the server.

This is most likely because the client build is out of sync with the server build. For instance, if the client is RTM and the server is SP2, or vice versa.

find out what build the server is and use the client tools from that build. Or just upgrade everything to the latest build.

---------------------------------------
elsasoft.org

Les Sprott Mr or Mrs. 500 Points: 567 More actions · Answer 3

Jezemine,

you are 100% spot on! Peer built the new cluster with an older version.

Thanks,

p_hil123 Valued Member Points: 61 More actions · Answer 4

am also experienced this error whenever i view my activity monitor tool on my sql server 2005, sorry sirs, but i still cant understand what to be done,

actually i upgraded my sql server 2005 from workgroup standard edition to SQL standard edition, i just copied my data files including all systems databases from previous edition of my sql after i installed it, then i got this error.

if you dont mind sirs, can u elaborate more what should i do? :hehe:

thanks a lot in advance.

lhurst SSC Journeyman Points: 88 More actions · Answer 5

I upgraded our server from standard edition to enterprise edition, and applied SP3 yesterday (2005). This morning I was using Activity Monitor fine but now I can't. Get the same error as above. So, I did an sp_who2 and notice a couple users running Crystal Reports. There are 236 processes/thread. One process had 90 threads, all suspended, with wait_type of CXPACKETS. Once this process cleared, I was able to use Activity Monitor. Am I hitting some type of maximum setting?

Thanks!

Dave McLaughlin SSC Rookie Points: 27 More actions · Answer 6

I'm encountering the same situation as lhurst (reply immediately above).

Can anyone explain that situation?

Thanks.

jezemine SSCrazy Eights Points: 8059 More actions · Answer 7

I explained it above. The problem is that the client tools (SSMS) you are using are out of sync with the server build. Most likely the client is old and the server is new. You need the client build to match the server.

---------------------------------------
elsasoft.org

niall.baird Hall of Fame Points: 3468 More actions · Answer 8

In my team, 2 of us cannot see the jobs in the job activity monitor, the rest can. We are all at the same level (patch level). Any other ideas?

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 9

niall.baird (4/13/2010)
In my team, 2 of us cannot see the jobs in the job activity monitor, the rest can. We are all at the same level (patch level). Any other ideas?

when i try to launch the active monitor from server itself ,it was giving the same error message what you have mentioned in initial post. After restarting the sql server active monitor working fine.

david.brown3 Grasshopper Points: 10 More actions · Answer 10

Hi,

I'm getting the same problem.I installed SQL 2005 SP 3 in October this year since then I've had no issues. However since some OS patching on 24/11 I now find I can't view the Activity Monitor from Management Studio I get the exact error shown in this thread. When I query the SQL Version it returns Sp1 . I know SP3 installed correctly as I have all the .txt files from the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix folder

A colleague has suggest that the OS patching has overwritten some SQL dll's can anyone confirm this could have happened?.He suggests just reinstalling SP3 will correct the problem again could someone confirm this ?

Random Visitor Old Hand Points: 384 More actions · Answer 11

I got this same message when an application was hitting the database heavily - many processes were suspended for a while - when the processes ended I could start up the activity monitor without any problem.

Linda Wenglikowski Old Hand Points: 381 More actions · Answer 12

I found same on SQL running on Windows 2008 R2 cluster. I opened Performance Monitor application. Expanded Data Collection Set, then both the system diagnostics and system performance. Found the arrow under the menu was green on both, so I clicked on them. This restarted the counters.

I then refreshed or opened new SSMS connection to my SQL Server I had issue with and opened activity monitor successfully.

Wish MS would have given this direction instead of Use the context menu in the overview pane to resume the Activity Monitor.

Hope it helps someone. I posted this on a few sites as I didn't find the answer online.