2

I am running a very old server that has a database that is being permanently retired within 14 months. My company will not invest anymore in hardware or software for this system as we are moving to a whole new system that is hosted within 6 months. I have only found reference to this Exchange Entry, but that is about servers and potentially using Virtual Servers.

My server services about 500 users, of which roughly 100-125 are concurrent during any given time of the work day. There are four 1.5 hr periods of very heavy activity during the day, and as the DBA and developer assigned to work with this server, I have about 1 hour in the morning and overnight jobs to do anything that could seriously impact performance for the machine. There are 2 active production databases on it that will be used until the change over occurs in 3-6 months, and a development instance that I use for testing/fixing issues, since this is the only SQL server left in the organization. (For those DBA's cringing at this point; All your DBA concerns about safe practice, let alone best practice, backups and DR, are valid and I have raised them, but they REALLY will not spend anymore on this system or the infrastructure. So a new box is Moot.)

So, I am left with the desire to throttle (if possible) the two production databases to use no less than 80% of the resources, and give me a 0-20% usage so that if I run something like a DBCC command on the DEV area, it does not chew up the resources and give me the rash of 50 phone calls from the production users 5 minutes later? I am looking for the ability to throttle so that I can do the data preparation and extraction testing as we migrate to the new system with out messing too much with the day to day business activity.

  • 1
    I'm assuming you're not able to run a dev instance on your PC with all or some of the relevant data? Not that that'd be ideal or anything, but it's something. – LowlyDBA Jan 23 '15 at 14:51
  • I have been trying to get that option, but the actual data base is big enough (14.5G) that SQLExp doesn't like it. I use subsets of tables locally sometimes in SQL2008r2Exp and Sql2012Exp depending on my machine. I just have to be able to run the scrub and export extractions on the server with as little impact on day-to-day operations. – Vanzanz Jan 23 '15 at 15:49
2

You could use the Windows System Resource Manager (WSRM) feature for this. It is not present in Windows starting from 2012 R2, but since this is an old SQL 2005, I would expect the OS to be old-ish as well.

I've never used it myself, but, though a bit complicated, it might do the trick for you.

  • If only I had a version of the OS that was as recent as 2008r2, I would; the OS is Windows Server 2003. And, Yes, I know, I said the same thing. ;) (/me puts the rosy sunglasses back on and keeps praying) – Vanzanz Jan 23 '15 at 15:53
  • 2003 has WSRM as well. It is limited to Enterprise and DataCenter editions, but it is availble. – spaghettidba Jan 23 '15 at 15:57
  • I will look into that this weekend! Thanks for an idea. – Vanzanz Jan 23 '15 at 17:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.