<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
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Sadequl Hussain
»
Saving Time with Proactive DBA Monitoring
18 posts, Page 2 of 2
««
1
2
Saving Time with Proactive DBA Monitoring
Rate Topic
Display Mode
Topic Options
Author
Message
BU69
BU69
Posted Wednesday, July 22, 2009 1:00 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, September 20, 2012 1:35 AM
Points: 133,
Visits: 280
An easier way to distribute monitoring jobs is to use the master and target feature that way you can implement all your jobs or maintenance plans on a central server which then distributes and controls the jobs even holding the logs centrally and this way you are gurenteed that all monitoring jobs on each server are exactly the same so no inconsistencies creep in.
Post #757175
Vee
Vee
Posted Wednesday, July 22, 2009 2:11 AM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, May 17, 2013 2:11 AM
Points: 409,
Visits: 408
I have already implemented such a design in my place. I believe much better to achieve the same is using the powershell, where you no need to create the linked server, as linked servers sometime can cause performance issues. Powershell is the best way to achieve the same.
Post #757205
BU69
BU69
Posted Wednesday, July 22, 2009 2:21 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, September 20, 2012 1:35 AM
Points: 133,
Visits: 280
Is that only in SQL 2008 though? It would interesting to hear more about this, there seems to be so many different ways now, especially with 2008, to administer SQL accross a few servers that it's really becoming an art in itself, which one is best? I've tried several different approaches but am still unsure that my master target method in 2005 is the best, it's certainly best for keeping it consistent but what is more efficient?
Post #757210
Vee
Vee
Posted Wednesday, July 22, 2009 2:35 AM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, May 17, 2013 2:11 AM
Points: 409,
Visits: 408
No need to have 2008. We can install on one server and can remotely access the data from the client server.
Post #757215
Vee
Vee
Posted Wednesday, July 22, 2009 2:39 AM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, May 17, 2013 2:11 AM
Points: 409,
Visits: 408
here is one link
http://www.simple-talk.com/sql/database-administration/why-this-sql-server-dba-is-learning-powershell/
Post #757217
Vee
Vee
Posted Wednesday, July 22, 2009 2:41 AM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, May 17, 2013 2:11 AM
Points: 409,
Visits: 408
Using the linked server concept, we also need to load the ole's in sql server to get the clients disk space data. using the power shell, its quite simple.
Post #757219
BU69
BU69
Posted Wednesday, July 22, 2009 7:45 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, September 20, 2012 1:35 AM
Points: 133,
Visits: 280
I read the article and it was very useful, some of the things like running queries accross multiple servers can now be done in SQL 2008 and some of the other tasks I could think of better ways to retrieve the information like disk space but for finding out Windows information I should think this is very useful, if I can't get our monitoring tool to pick up information from the event viewer I will look into this as a way of getting this.
Post #757438
PugMaster
PugMaster
Posted Monday, July 27, 2009 4:46 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, November 22, 2012 1:35 AM
Points: 23,
Visits: 168
I have done a similar thing with SSIS, you just need to add the new monitored instance into a table in your repository and ensure the account running the package has permission on the target Instances. I then have 3 packages, one that runs stat's daily, one that runs hourly and one that checks status, agent heart beat, PLE etc every 5 minutes. I then have a aspx page looking at the repository for status info and some reporting services reports pulling of trend graphs etc.
I beleive i got the original SSIS packages from a feature on this site and modified it to add more metrics and update the code for SQL 2008 instances.
Cheers, Paul
Post #759956
« Prev Topic
|
Next Topic »
18 posts, Page 2 of 2
««
1
2
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.
