May 24, 2007 at 10:34 am
We have several sql 2000 servers. Each box is not overutilized (based on CPU and disk queue length) so we want to combine them into a single server.
We could create multiple sql instances on the new server, corresponding to each of the individual sql servers, or attempt to consolidate all the sql databases into a single, default, instance.
Are there any principles, whitepapers, licensing issues, etc. that can guide in making the "proper" decision?
Barkingdog
May 24, 2007 at 12:18 pm
There was a good article on consolidation on this site a while back. I'm sure if you searh for it you can find it.
I did a server consolidation project at my last job. We ended up building a four node cluster with four instances (active/active/active/active), so it's not quite the same as your situation. Larger applications which might need more dedicated resources (i.e. their own tempdb) would end up on their own dedicated instance. But most of the smaller databases could go onto a single instance. Worked like a charm for us and we were able to really cut out some server sprawl issues we had.
May 25, 2007 at 2:33 am
- there are # articles at SSC and sql-server-performance.com
- Keep in mind you need to determine criteria for databases to be hosted in an instance.
e.g.
- how/when will you be able to perform maintenance (sp or dbmaintenance) to an instance.
- what are the usage-characteristics for the db (olap-like or oltp) to exclude cpu- or memory-hogs.
- can all applications live with the fact that you bring down and instance for maintenance because one of the databases applicationservers are being "in progress of application maintenance"
- security implications (who is dbo / sysadmin / jobadmin ?)
- can your box handle the load ....
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 25, 2007 at 8:57 am
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply