May 11, 2010 at 12:09 pm
Hi, I remember my DBA 10 years ago advised not to have more than one DBA monitoring CPU usage using Task Manager at the same time because it would use additional CPU on the DB server. I am wondering if this is just a myth nowadays with the server speed nowadays? There's 8GB of memory on my server with 2 Quad core CPUs. Thank you.
May 11, 2010 at 12:25 pm
I guess the answer depends on what they're monitoring with. For example, I'd hate to see two or more copies of Quest Spotlight connected to my production server. But two copies of perfmon... that's probably not that big a deal. Certainly more than one person can run DMV's against the server at the same time... I'm going with "it depends"
"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 11, 2010 at 12:44 pm
Thanks for the reply. I usually noticed that the CPU spikes when Task Manager is started. So I am always a bit leery seeing 2 people running Task Manager on the same server. But at the same time, I tell myself that the server should have enough resources to handle 2 running Task Manager.
Since it's a question that lingers in my mind, I thought I had post this on the forum and see what others have to say. Appreciate your input. I wonder if anyone else would like to drop in a quick line what you think. Thanks.
May 11, 2010 at 12:59 pm
lkean66 (5/11/2010)
Thanks for the reply. I usually noticed that the CPU spikes when Task Manager is started. So I am always a bit leery seeing 2 people running Task Manager on the same server. But at the same time, I tell myself that the server should have enough resources to handle 2 running Task Manager.Since it's a question that lingers in my mind, I thought I had post this on the forum and see what others have to say. Appreciate your input. I wonder if anyone else would like to drop in a quick line what you think. Thanks.
Oh, but that's implying that you're RDP'ing to the server... multiple people, well, anyone, connecting that way would cause me concern.
"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
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply