2,072 reputation
819
bio website
location Wetherby, United Kingdom
age 44
visits member for 5 years, 7 months
seen Aug 28 at 8:02
Database manager and DBA for SQL Server and Oracle. IT Operational Support manager (a technincal boss). Occasional classic ASP and C# web programmer.

Nov
30
comment SQL Server performance triage?
Also worth checking if your RAID 5 is showing a fault. You can get "drops like a stone" performance hit if your RAID array loses a disk and a rebuild is in place, or the battery backed write cache goes on the blink.
Nov
12
comment vmware ESX 4 with AMD Opteron 2435 MHz 6 core CPU's. CPU-Z reports core speed 528Mhz!
Still working with the server admin to agree to test this in more detail. Not convinced that the server is working at full power, but the server admin want's it to work "efficiently". I want my SQL queries to run faster (MS CRM) without throttling up and down MHz.
Nov
12
revised vmware ESX 4 with AMD Opteron 2435 MHz 6 core CPU's. CPU-Z reports core speed 528Mhz!
added 109 characters in body
Nov
11
comment vmware ESX 4 with AMD Opteron 2435 MHz 6 core CPU's. CPU-Z reports core speed 528Mhz!
Will have a play on a test blade and vm... Brent did say he'd seen the same thing on vm's as well as physical boxes, but you never trust anything anyone says, do you ;)
Nov
11
comment vmware ESX 4 with AMD Opteron 2435 MHz 6 core CPU's. CPU-Z reports core speed 528Mhz!
It's not quite that simple, but we should be able to check the config in a sister server/blade to see what that is doing. Hopefully tomorrow.
Nov
11
comment vmware ESX 4 with AMD Opteron 2435 MHz 6 core CPU's. CPU-Z reports core speed 528Mhz!
@Marm0t - It seems they are set to "dynamic" or "OS Control" mode. But the ESX server is reports the "Power Management Technology" as "Not available". Does the serve default to slow mode?
Nov
11
revised vmware ESX 4 with AMD Opteron 2435 MHz 6 core CPU's. CPU-Z reports core speed 528Mhz!
added 413 characters in body
Nov
11
revised vmware ESX 4 with AMD Opteron 2435 MHz 6 core CPU's. CPU-Z reports core speed 528Mhz!
added 98 characters in body
Nov
11
revised vmware ESX 4 with AMD Opteron 2435 MHz 6 core CPU's. CPU-Z reports core speed 528Mhz!
More info.
Nov
11
comment vmware ESX 4 with AMD Opteron 2435 MHz 6 core CPU's. CPU-Z reports core speed 528Mhz!
Windows 2008 and this guest has 4 CPU's (as per the taskmanager photo) and I'm running a lot of 7zip's to get the CPU up high to try to see if the buz speed pops up...
Nov
11
asked vmware ESX 4 with AMD Opteron 2435 MHz 6 core CPU's. CPU-Z reports core speed 528Mhz!
Nov
9
comment SQL 2008. I have user in a db which has no login on the server. How is it possible?
@Bobb - good luck with that! I hope your DBA's are tame...
Nov
9
answered How do we quantify the impact of a lower memory speed on a VMware ESXi host?
Nov
8
answered WHEN Do you start using Load Balancing against two servers?
Nov
4
awarded  Popular Question
Oct
11
answered How to detect Windows Server 2003/2008 Release (R1 or R2) programatically?
Oct
2
answered Why does SQLServer 2008 R2 take hours and hours to uninstall?
Sep
27
accepted How can I find out how many updates are waiting to be installed on a remote server
Sep
23
answered How can I find out how many updates are waiting to be installed on a remote server
Sep
23
comment How can I find out how many updates are waiting to be installed on a remote server
Thanks - I looked at UpdateHf.vbs and worked out how to use CreateObject("Microsoft.Update.Session", strServer) in VBScript to create a small script to check a servers "not installed" status.