2,032 reputation
719
bio website
location Wetherby, United Kingdom
age 44
visits member for 5 years, 2 months
seen Jun 4 at 12:23
Database manager and DBA for SQL Server and Oracle. IT Operational Support manager (a technincal boss). Occasional classic ASP and C# web programmer.

Nov
22
comment “Operating system error 1394” - How can I prevent it?
@syneticon-dj : 50+ SQL instances and several hundred databases and in the middle of the night? I need my beauty sleep mate! It seems to be a temporary glitch thing, and my script will just try again in 10 minutes or so. But I do get error message emails for every fail and, well, I shouldn't be getting these errors!
Nov
21
comment “Operating system error 1394” - How can I prevent it?
@syneticon-dj : Thanks, I did see that! My 'huntch' is that it's to do with Active Directory authentication tickets that are being rejected - maybe because of a time sync issue between the servers. But this is just a guess and I'd like something to back that up...
May
18
comment How can I find out how many updates are waiting to be installed on a remote server
@ST8... I would run this using runas /user:youraccount cmd to create an authenticated shell and then run the script.
Feb
4
comment Robocopy: How to move the content of a directory but KEEP the directory
@Chris. A little harsh methinks. The answer was valid apart from the "parent directory" requirement, and I did ask for clarification which that was only availanble after I posted the answer. Using my answer you could use the /XD or /XA parameter.
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
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
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
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...
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.
Sep
17
comment How much RAM for a web server?
512GB for a webserver is fine. If there are no users! Please provide us with more details: How many concurrenty users do you want to support? How does the server perform in your dev and test environments?
Aug
11
comment Robocopy: How to move the content of a directory but KEEP the directory
That would be a.... copy? Sorry - don't get what you're trying to do. *If it is just a copy, then use /S
Jun
7
comment SQL Clustering on Hyper V - is a cluster within a cluster a benefit
You do need to ensure that your storage infrastructure can cope with 20 or 30 SQL servers running at the same time. It's easy for a storage expert to say "yeah, it's fine" but you have to multiply everything by the PEAK of ALL the servers (How long is your backup window?) and still have enough left for growth. My storage and back-end requirements have 10x in the last 3 years!
Jun
7
comment SQL Clustering on Hyper V - is a cluster within a cluster a benefit
If you read my other posts, I'm a HUGE fan of virtualisation. I prefer vmware ESX (I still feel Hyper-V is playing catch up). Big wins for availability (HA, DRS), maintenance and flexiblity. But - you still need maintenance windows! Given MS publishes updates on "patch Tuesday", we have a "patch Sunday" each month that gives us enough time to test the patches on test servers, and than schedule reboots (if required) with the business.
Mar
10
comment Which SQL Server version to install on Windows Server 2008 R2
+1 for information, but -1 for spelling? (Sorry if English is not your native language though)
Feb
16
comment better cpu or more memory for development machine
RAM. You Need More RAM. Then More Disk Space. CPU's spend 80% of their time doing nothing. Even when they are busy they are STILL waiting for RAM!
Jan
22
comment ESX 3.5 Resource Groups
Answer given to @Helvick as it is the correct explaination of Resource Group shares. But it does not answer the bullet points at the end of the question. Yes, placing 'Sharepoint' into a group gives it less shares, but that's what I want it to do. I do not want 'SharePoint' (a limited use system) to have a disproportionate share of CPU/RAM compared to more important systems (SQL Server). SharePoint should 'lose' the same amount of resources as the other systems and not be a special case. Anyway - thanks for your help.
Jan
13
comment ESX 3.5 Resource Groups
Thats what I thought. So while the cluster is running smoothly then it makes no difference how I set up the shares and it will not stop SharePoint (or any other server) from getting as much resource as it requires.