August 12, 2010 at 4:47 am
Hi All,
Is there a way I can calculate and say that this SQL server can support only a maximum of these number of databases with the available resources (like with this amount of RAM and CPU)
Say for example . I have a two node cluster instance (Active/Active) and have one instance up on each node , have RAM of 65 GB and sql have max memory assigned as 45 GB in each instance with 8 CPU (lets say dual-pro) .
Now is there a way I can show / say that with this available resources we can handle not more than 50 databases
(or) the maximum size that drive can have is 2 TB of data disk ? (considering the time it takes for fail-over and future growth of databases in next few years etc)
(or) can I say this setup can handle user connections of 32,767 with the available resources ???
If so is there any tool or process we can follow to show / say that, yes this server / setup has reached its max. capacity so every new databases needs to be pushed to another server / setup ??
Any idea or guidance would be of great help..
Thanks
Madhava rao.M
August 12, 2010 at 11:29 am
I am going to say no to that, because I have seen database/application that only one database can be on server. Or others where have 200+ databases on server.
There is never a clear cut answer to how many databases can go on server. Question comes down to usage of the database(s) in question. If you are implementing a new installation of SQL Server, then you need to ask the business users their requirements and make judgment from there. It is always hard to make decision as you don't want to invest too much money into hardware and not use it; but also don't want to buy hardware that doesn't even last few months.
If it is existing server, then you can base your numbers on existing pressure and if you have baseline setup for server; then you can compute the growth over time and expected growth over 2 years, 3 years, etc. whatever your business requirements are.
Another note, on a active-active instance with 65gb ram on each server you want to limit the sql memory to 30gb; there by making it that each SQL Server if they are on same node sum up to 60GB+5GB for OS.
Cheers.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply