<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Backups
»
Monitoring script
Monitoring script
Rate Topic
Display Mode
Topic Options
Author
Message
k2000rajesh
k2000rajesh
Posted Monday, December 21, 2009 4:51 AM
Grasshopper
Group: General Forum Members
Last Login: Friday, February 26, 2010 10:44 AM
Points: 10,
Visits: 28
what is monitoring script in sqlserver 2005 how to implement it?
Post #837078
Grant Fritchey
Grant Fritchey
Posted Monday, December 21, 2009 6:43 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 4:50 AM
Points: 13,371,
Visits: 25,143
You need to provide a little more information for what you're looking for. Monitoring what? There are lots of things you could monitor on the server, performance, access, data, and those are off the top of my head. The reason you need to specify is because you'll do different things depending on what it is you're looking for.
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #837129
k2000rajesh
k2000rajesh
Posted Monday, December 21, 2009 8:04 AM
Grasshopper
Group: General Forum Members
Last Login: Friday, February 26, 2010 10:44 AM
Points: 10,
Visits: 28
iam installing sqlserver 2005 on my machine
how to impliment essantial monitoring script on local Box
Post #837206
Grant Fritchey
Grant Fritchey
Posted Monday, December 21, 2009 8:26 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 4:50 AM
Points: 13,371,
Visits: 25,143
Monitoring for what? To ensure up time? To observe performance? To see who is going to access your system? I'm sorry, but each of these will have different requirements and I still don't understand specifically what you're looking for.
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #837219
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Monday, December 21, 2009 9:06 AM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406,
Visits: 13,722
If you don't know what monitoring is, then we likely won't be able to provide much help until you start to spend some time learning. There is no "monitoring script" that I'm aware of for SQL Server, or really for any system. Even the third party products you buy monitor all sorts of different readings on a server to determine if something is working or not.
I would suggest you take a step back and think about what it is you are missing, or what you'd like to do Or ask the person that assigned this to you what they would like monitored.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #837262
GSquared
GSquared
Posted Monday, December 21, 2009 9:14 AM
SSCoach
Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439,
Visits: 9,569
k2000rajesh (12/21/2009)
iam installing sqlserver 2005 on my machine
how to impliment essantial monitoring script on local Box
I recommend taking a look at RedGate's SQL Response product (link is at top right of this site).
Without more specifics on what to monitor and why, I can't recommend a specific script. But SQL Response will monitor just about everything you would want, so definitely take a look at it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #837271
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
