Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2009-04-06 : 19:18:21
|
| Hi Experts,Thanks once again for all the solutions one and all has provided to me, so far.This time I do have the server side capacity calculations to be done, for which we do have the server and its current allocations such as RAM, number of processes, memory allocations etc.However, I would like to upgrade this server to a newer capacities of the items I have mentioned above. Can you guide me as to how I need to calculate these parameters back to me using the input of the present parameters?Do I need to do any DMV's usage etc OR do I need to calculate the with any such method I need to follow.Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-04-06 : 19:21:47
|
| There isn't a formula to use. It's just based on the admins (server and database) best guess based upon experience and hopefully load testing. Here are some questions I'd ask:How big is the database now and how big will it be in the next couple of years?What are its uptime requirements? How fast should queries return? How many concurrent users will there be?How many batch requests per second?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-04-06 : 20:50:33
|
| Thanks Tkizer.Can you give some more Clues on the "points you have mentioned" as to how I can proceed with them.Thanks in advance |
|
|
|
JKOOL
Starting Member
1 Post |
Posted - 2009-04-06 : 23:28:07
|
| Hi PDset,What is it that you try to accomplish? Why are you replacing the existing box? Performance issues?, Growth expectations?, Hardware life cycle replacement?. You have one very valuable asset at hand, the current server. Analyze this box, get the metrics and growth trends, and size upon those figures.Just a little footnote, if you are facing performance issues, hardware is often the smallest factor. Usually performance issues are related to poor queries, and missing key indexes.good luck,.J. |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-04-07 : 05:11:22
|
| Collect the CPU, Memory usage , Disk usage and all the counters from Perfmon and export it in a table. I would suggest you do this atleast a week to include all the activites.(You may have weekly maintenance plans).Do your analytics thenhttp://www.sqlserver007.com |
|
|
|
|
|
|
|
|
Server side calculations