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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 How to get the capacity of server ?

Author  Topic 

arvind_ramugade
Starting Member

30 Posts

Posted - 2012-08-02 : 15:45:42
Hi,
How to know the capacity details for SQL server ?
is there any utility available to know it ?


ramugade

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-08-02 : 15:48:15
See if this page gives you the information you are looking for: http://msdn.microsoft.com/en-us/library/ms143432.aspx
Go to Top of Page

sql-lover
Yak Posting Veteran

99 Posts

Posted - 2012-08-04 : 00:16:22
If you are referring to what your server is capable right now or it's current utilization, use Perf. Mon. Let it run for a few days or a week and create a baseline.

Common counters are CPU and RAM utilization, page life expectancy, user connections, disk latency.
Go to Top of Page
   

- Advertisement -