Server Farm Reporting

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Mark Tierney » Server Farm Reporting - Part 1

13 posts, Page 1 of 2

1 2 »»

Server Farm Reporting - Part 1

Rate Topic

Display Mode

Topic Options

Author

Message

bnordberg

Posted Monday, July 16, 2007 4:24 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 9:10 AM
Points: 267, Visits: 344

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/mtierney/3103.asp

Post #382128

Zubeyir

Posted Wednesday, August 01, 2007 12:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 09, 2012 6:44 AM
Points: 167, Visits: 87

Quite excellent and reporting services is a good idea. But we sometimes need just need to know more than the free space in db files. In these cases I personally suggest MS MOM (MS Operations Manager). I know it costs but it really helps you with every details of reporting. Besides it does not have a simple UI as yours.

Zubeyir

Post #386886

Steve Maxwell-405660

Posted Wednesday, August 01, 2007 2:32 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 26, 2010 3:21 AM
Points: 50, Visits: 97

Another option is SQLH2 which comes with a reporting pack and a comprehensive stack of supporting tables.

http://www.microsoft.com/downloads/details.aspx?familyid=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en

Post #386906

MVDBA

Posted Wednesday, August 01, 2007 4:04 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, April 29, 2013 10:15 AM
Points: 2,261, Visits: 758

This is something i've been looking at for a long time and it's intersting to see how other people approach the problem.

unfortunatly I came across a stumbling block in using linked servers and MSDTC that prevented me from getting all teh monitoring info i wanted.

sure you can execute myserver.master.dbo.xp_fixeddrives and pull the info back to your repository.

but you can't run DBCC commands via a linked server (try it- dbcc is not associated with any database!)

in the end we've written a custom activex control (so it will be sql 2005 and 2000 compatable) which can run any query against a list of servers and put the results in the repository.

i'm happy to supply source code for the module and procs to run it if anybody is interested.

MVDBA

Post #386918

JohnMarks

Posted Wednesday, August 01, 2007 6:46 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 03, 2013 8:44 AM
Points: 61, Visits: 419

Nice article and the reports look great but you seem to be reinventing the wheel. Check out sql health check. Pretty easy to implement and it can collect a lot of data. As the other poster pointed out it comes with over half a dozen reporting services reports.

Post #386956

Simon Facer

Posted Wednesday, August 01, 2007 7:25 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:30 AM
Points: 1,566, Visits: 600

We had the same problem - 80+ servers, 800+ databases. I also went with Pull architecture, but everything is run from the data warehouse server (SQL 2005) using dynamically created (created and dropped after the calls) Linked Server, we decided we didn't want the overhead of implementing and maintaining code on every server we own (we're trying to reduce our workload after all).

Post #386976

MVDBA

Posted Wednesday, August 01, 2007 7:34 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, April 29, 2013 10:15 AM
Points: 2,261, Visits: 758

but if you're using linked servers how are you running commands like

dbcc sqlperf(logspace)

which would tell you if a log were large or not required intervention (i.e a developer has deployed a new database in the wrong recovery mode on your dev server)

MVDBA

Post #386979

Mark Tierney

Posted Wednesday, August 01, 2007 7:42 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 17, 2012 7:25 AM
Points: 30, Visits: 208

I was unaware of Health Check. I'll definitely check it out.

Thanks, Mark

Best Regards,

Mark Tierney

Post #386984

noeld

Posted Wednesday, August 01, 2007 9:06 AM

SSCertifiable

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:39 PM
Points: 6,260, Visits: 1,977

It *is* doable:

select a.* from
openquery(SERVERNAME,'SET FMTONLY OFF; EXEC(''dbcc sqlperf(logspace)'')') a

Just make sure that:
1.you have the necessary permissions
2.lazy schemavalidation = true

Cheers!

* Noel

Post #387049

Rudy Panigas

Posted Wednesday, August 01, 2007 9:09 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:38 AM
Points: 306, Visits: 1,012

Hello Everyone,

Just looked at the article and see that some people want to execute DBCC commands on a remote server. I not sure you want to do this as it is a power full tool and you can really make a mess of things. To collect data and stats is one thing but to do anything else, I believe that you should be doing that on that server, not remotely.

I've written my own server farm code that performs the same function but I've been playing with Quest SpotLight for SQL Servers Enterprise and it really does the trick. If your company has 30+ servers that you are maint/manage/monitoring then you should get them to spend some money and get something with more teeth. The app does real time monitoring and historical data collection, which is great for diagnosing an issue. I also use another product call Capacity Manager from Quest (..no I don't work for or get kick backs from Quest!) it too has tons of information on growth, growth patterns, disk space etc.

Check them out I think you will find them worth the talk to you management.

On a side note, I use my "home grown" code to produce an hourly report that show all failed jobs on all SQL servers. The developer have access the test/uat/dev reports and we look at the production reports. It's a great way to see what's happened or happening on a job level.

Just my 3 cents worth : )

Post #387052

« Prev Topic | Next Topic »

13 posts, Page 1 of 2

1 2 »»

Permissions