May 15, 2009 at 12:42 pm
Basically, is there a way to Ping/Query 2000, 2005, and other 2008 servers from a report services page? I will be happy to clarify if you tell me what kind of info you want (I'm a student, I've been working on all sorts of 2005-2008 stuff for a semester, but I'm still relatively new)
May 18, 2009 at 2:23 pm
*bump* - also, I'm just trying to figure out a way to get the status info for any other server on the network from a central sql 2008 server. If this is possible, what is a good way to do it?
May 18, 2009 at 3:16 pm
Check the links below for Microsoft sample code that is SQL Server Management, no I have not used those you are a student so try out the samples and post again.
http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-performance-data-collector/
😉
Kind regards,
Gift Peddie
May 18, 2009 at 5:04 pm
I'm looking into that second artical, a lot of it looks very promising... the one thing I would like to be able to get is real-time report of services. I've spent a few hours today looking around trying to figure out how to do that, and I'm still not sure how to do it.
C#/J# both seem to have ways to monitor services, but I'm not exactly sure how to program in either language (shouldn't be too terribly bad to learn another language, but it would certainly be easier not too) - also I've been encouraged to stay within SQL if at all possible.
Powershell can monitor services for sure, and I have made powershell batch files in the past, I know the very basics of that language - in 2008 there is built-in support for powershell, but I don't believe the security permissions will let me do everything - only the stuff made for sql 2008.
Basically, I feel confident that with enough mulling around, I can figure out how to sent information from any sql server to my server at regular intervals, and then report on that data (which is what that artical is as far as I can tell), but I'm not sure how to make it so that when I click a link in a report, I can tell if the database service and the analysis services are running, what the current cpu useage is, etc. If anyone happens to know what would be the best way to do that, asside from 3rd party scripts, please let me know!
Also, one last thing, is there a way to set triggers for jobs, what about triggers for windows schedualed tasks? either of those might be benifitial. Thanks!
May 18, 2009 at 5:35 pm
I cannot help you with Triggers because those are almost obsolete so I don't use it, here is an article for the file I gave you to download this could give you ideas.
http://msdn.microsoft.com/en-us/library/aa964131.aspx
Kind regards,
Gift Peddie
May 18, 2009 at 5:47 pm
If triggers are obsolete, how would you do this sort of thing? - I have yet to fully check out the link you just gave me.
May 18, 2009 at 6:02 pm
SSRS is resource intense service so it is not practical to use it in real time for anything before the next version of SQL Server which can run real time. And I don't think you can use trigger with Windows Scheduler however you could run trigger with Agent Jobs. So you need to read that article run the code and see what you can change to make it better, do some work before posting.
Kind regards,
Gift Peddie
May 19, 2009 at 2:49 pm
Alright, thanks for all the help, the data collection setup in 2008 is really good, I don't think I can do anything more with it than it has, without realtime stuff. About the only thing I'd really like to do with it now is be able to modify the reports that it lets you look at, and stick them in report services so that I can see them from a web browser.
this will probably take care of over 50% of this project if I can figure out how to replicate some of it for 2005 (the other link looked promising for that, 2008 is my primary focus though), and if I can modify it to show what I want, and possibly tone down the list of stuff that it scans for (to save on cpu useage on production servers).
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply