SQL Server Performance Forum – Threads Archive
Monitoring for capacity planning
Hi 1I need to monitor sql for capacity planning.
Actually Tivoli specialist will do it using Tivoli monitoring tool i just asked him what counters i need . I will do it twice a week for 6-7 hours (on busi and light days) I am not sure if interval in 30 min is reasonable to catch the main 13 couters for this purpose.
Could someone help?
I am not familiar with the Tivoli monitoring tool, but if I were doing the same with Performance Monitor, I would capture the data, 24 hours a day, 7 days a week, with a collection interval of every 60 seconds. This is a lot of data, but if you need an accurate snapshot of how things are going now, the more detail you can capture, the better your information will be to make future assessments. To minimize the impact on SQL Server, be sure the monitoring tool is running on a server other than your SQL Server. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
This is what i originally wanted to do but the Tivoli person recomended for even 1 hour.
He concerned about impact on severs even though i looked in task manager this tivoly service take tiny cpu and memeory. what about reads?
As suggested by Brad, the sampling interval should be short enough to give some meaningful data. The impact of monitoring on server depends on the no. of counters measured as well. I would recommend going through this website for more details on performance monitor counters. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
We use Tivoli monitoring tool but capturing counters every hour with no issues and make sure you’ve required disk space and no issues in the network. FOllow the thru the tips category under this website for more information on PERFMON counters. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Now i confused <img src=’/community/emoticons/emotion-3.gif’ alt=’
‘ />ne people sugest minutes others hour.<br />This person that wanted to capture those 13 counters on our end explained that by theory <br />posibility even with interval 1 hour you never will hit the same value.You still will have different numbers.<br /><br />And also why would i need disk space : we will actually capture data to access db only for 24 hours and then it’s will go to other db on other location.And the current access db will be overwriten.<br /><br />
I’d just conveyed the process we follow at our end and disk space note is to alert it may lead to other issues. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
OKEY ,tHANK YOU I WILL START FROM 30 MIN JUST IN CASE
For information refer to this MSDNhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/bdadotnetarch081.asp link about Tools for Capacity Planning where no third party tools involved. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>