Capacity Planning - CPU - SQL Server Forums

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)

Capacity Planning - CPU

Author

Topic

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2012-03-08 : 17:32:38

Hi,

How to check CPU usage with respect of SQL Server users and predict for any future growth (for next 2-3 years). How to calculate this data?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-08 : 18:07:38

You would need to do adequate load testing.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-08 : 18:10:57

Start with baselining your system. You can use this script to record it in T-SQL: http://troubleshootingsql.com/2009/12/30/how-to-find-out-the-cpu-usage-information-for-the-sql-server-process-using-ring-buffers/

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources