August 14, 2008 at 9:22 am
When I try to open activity monitor tool, it doent allow me to do so, I get an error message like
"not enough permission and timeout ellapsed" anyone knows whats going on.
abhisek
August 14, 2008 at 9:41 am
Sorry for asking the obvious, but do you have enough permissions?
August 14, 2008 at 10:14 am
Yes I do have sysadmin role, well sometime it opens but after a while it doesnt open.
August 14, 2008 at 10:16 am
If it opens sometimes and not others than I would guess that the second part of the error "timeout elapsed" is the more relevant piece. Are you having performance issues on the server? Network connectivity issues? Check to see if you are getting blocked by another process.
August 14, 2008 at 10:21 am
Yes I am having performance issue with this server and blocking also. How do I get rid of these problem, well I dont have remote access to the server, i am connecting sql server with a client tool only.
August 14, 2008 at 10:33 am
Well the standard answer to that question is, "it depends". This is a very broad question. At a minimum, you need to run a combination of sp_who2 and sp_lock to determine who is doing the blocking and on what objects the blocking is occurring. There are some scripts on this site to assist you in determining where the blocks are coming from.
Once you know where the blocks are coming from, you can more easily address them.
I would also recommend breaking out the performance monitoring tools and seeing if/where you are having hardware contention/bottlenecks.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply