April 27, 2010 at 7:50 am
Hello,
I have created a user defined data collector set to begin collecting some metrics of performance on a sql server 2005. The problem is that my data collector set is stuck in a pending status.
In pending status I can't stop or delete the data collector and it appears no data is being collected as I see nothing in the performance monitor screen and no logs are being created.
There are time limits provided that do not seem to be correctly stopping my scheduled data collector either.
I have tried restarting my own machine. Since this is actually running from my machine I see no need to restart services on the monitored server.
I am running the perf mon from my machine (sql 2008) connecting to the server I choose to monitor (2005). I am using the "default" to connect. I have sa rights to both.
Please advise as I can't find anything online via google where someone has experienced a similar issue.
April 28, 2010 at 6:20 am
I don't entirely understand the issue. Are you saying that you're running perfmon across the network to collect data? Generally, this is not an approach I use. Instead, I'll run perfmon on whatever server I need it to be running on and output the counters to a file on that server. Then you can take the file to your local box and peruse the data collected at your leisure.
Specific to your issue, can you provide a few more details of how you've set up perfmon?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2010 at 12:13 pm
Thanks so much for your reply.
I set up the perfom from my machine. I select the computer I want to monitor by select remote computer to run perfmon from my machine but collect results from a remote computer.
I am using this method as it was advised by an expert in the field that I just saw speak at a local SQL Saturday from PASS. He said not to remote desktop and set up perfmon directly on the prod box but rather set up perfmon directly on my own box. He recommends running from your own machine to make impact the most minimal. If I were to remote in and set it up that way he said there would be some impact slower.
Now…my problem is that the the data collector is stuck in pending. It is not collecting, if it is, it is not logging. I can’t stop or delete the collecton of data.If you can see below, the process is hung in pending. The status shoud be either stopped or started, right? This is defintely a prolem. I want to see results =)
I have no idea how to add images here and have limited image collection on the machine i run.
April 28, 2010 at 12:53 pm
izdede (4/28/2010)
Thanks so much for your reply.I set up the perfom from my machine. I select the computer I want to monitor by select remote computer to run perfmon from my machine but collect results from a remote computer.
I am using this method as it was advised by an expert in the field that I just saw speak at a local SQL Saturday from PASS. He said not to remote desktop and set up perfmon directly on the prod box but rather set up perfmon directly on my own box. He recommends running from your own machine to make impact the most minimal. If I were to remote in and set it up that way he said there would be some impact slower.
Now…my problem is that the the data collector is stuck in pending. It is not collecting, if it is, it is not logging. I can’t stop or delete the collecton of data.If you can see below, the process is hung in pending. The status shoud be either stopped or started, right? This is defintely a prolem. I want to see results =)
I have no idea how to add images here and have limited image collection on the machine i run.
The process is hanging on your local machine or on the network machine? I'm assuming your local machine. I'd just kill the process or bounce your machine. Either one should clear it.
If you're getting hung while running it from your local machine, that implies network issues. I'd suggest then running perfmon on the server itself. I usually run it locally on the servers and haven't had any issues. As long as you're outputting to a file, you shouldn't seriously impact the server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 29, 2010 at 10:38 am
Yes, that is the problem since the process/task/data collection set is hung in pending I can't even delete it.
In fact, I have tried restarting my machine to no avail as well.
That is why I am so puzzled and seeking assistnace :crazy:
April 29, 2010 at 10:42 am
izdede (4/29/2010)
Yes, that is the problem since the process/task/data collection set is hung in pending I can't even delete it.In fact, I have tried restarting my machine to no avail as well.
That is why I am so puzzled and seeking assistnace :crazy:
If it's running from your machine and stored on your machine, rebooting has to break the connection. It sounds like it's not running or not stored on you machine.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 4, 2010 at 9:00 am
Thanks for all your help but as I thought, which is why I chose to post here, the solution seems to be a moving target.
Both my machine and the SQL Server in which this user defined data collection where the data was supposed to be collecting from (prod server) and configured from (my localhost) have been rebooted but the task still appears to be hung in pending. This just doesn't make sense.
We can say, sure we are confident the connection is broke but
a) why does the data collection set still display as pending, why can't the set be deleted, or stopped
b) what are the odds I try to setup and run the set again, configured similarily (but on the prod box) that I won't get the same results?
oh boy! :unsure:
May 4, 2010 at 9:26 am
izdede (5/4/2010)
Thanks for all your help but as I thought, which is why I chose to post here, the solution seems to be a moving target.Both my machine and the SQL Server in which this user defined data collection where the data was supposed to be collecting from (prod server) and configured from (my localhost) have been rebooted but the task still appears to be hung in pending. This just doesn't make sense.
We can say, sure we are confident the connection is broke but
a) why does the data collection set still display as pending, why can't the set be deleted, or stopped
b) what are the odds I try to setup and run the set again, configured similarily (but on the prod box) that I won't get the same results?
oh boy! :unsure:
Something else is going on. Unless you have something that restarts the job on boot, it can't keep running when your machine is switched off... I tested this on my own machine. Everything goes away. You may need to open a call with PSS.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 24, 2010 at 7:52 am
Well thx for all your time and efforts.
I think what finally resolved the issue was a "simulataneous reboot" of both machines.
It seems like if one was taken down while the other was still up...the problem appeared to linger.
However, I left my machine shut down for an extended period of time and had the sql server machine in question rebooted during that time.
Finally, I think things cleared up. There is some reason to believe that having that collection set out there hung was beginning to impact the server as well as CPU utilization appeared highter than normal with littely other activity and slowness when data was being accessed via report or CRM applications etc.
Just wanted to keep you informed since you took the time.
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply