November 22, 2010 at 1:15 am
Hi,
I need to collect tempdb object creation rate and size of temp db every half hour…
Collect the information for 2 weeks and then create my monitoring report.
Is there any easy way to do this rather than noting it every half hour/day by using scripts..
I cannot create any objects in my system.
Thanks
November 22, 2010 at 1:19 am
Create a SQL Agent job, schedule it every 30 min. If you don't have permission to create it, ask your DBA.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 1:23 am
Sorry, we cant any jobs on the system.
(coz creation one requires a big long chain of getting approvals from everybody and it would never be approved just for single report)
Any other way, that stores the info
(by the way i'm the DBA here 🙂 )
November 22, 2010 at 2:45 am
There's nothing built-in that stores that.
Why would a monitoring job not be approved? Surely management wants the servers monitored?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2010 at 2:49 am
there exists monitoring by using some 3rd party tools (which are great).
In addition a report is generated every 2 week to get short summary and inform management about stats and health.
I know they would say, since this report is for very low priority, better do it manually..(which i hate)..
such is the business!!!!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply