Monitoring on a Budget

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 Bert Carles » Monitoring on a Budget

20 posts, Page 1 of 2

1 2 »»

Monitoring on a Budget

Rate Topic

Display Mode

Topic Options

Author

Message

Bert Carles

Posted Sunday, November 18, 2007 12:02 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, July 31, 2008 9:29 AM
Points: 1,800, Visits: 154

Comments posted to this topic are about the item Monitoring on a Budget

Take care,

Bert

"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday

Post #423370

K. Brian Kelley

Posted Monday, November 19, 2007 3:47 AM

Keeper of the Duck

Group: Moderators
Last Login: Yesterday @ 1:13 PM
Points: 6,584, Visits: 1,790

This is a nice write-up. I know a few folks who could use this. On a related note, how are you moitoring the performance counters outside of SQL Server, such as CPU usage, pages/sec, etc.? Or are you strictly concentrating on SQL Server?

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog |

LinkedIn | Twitter

Post #423485

Bert Carles

Posted Monday, November 19, 2007 5:52 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, July 31, 2008 9:29 AM
Points: 1,800, Visits: 154

To be quite honest, I hadn't thought of monitoring counters outside of SQL Server. You've sparked my interest.

We did add code to track disk space when we were trying to justify additional SAN space. The overall process is the same; simply capture today's disk utilization and subtract yesterday's from it to get a daily increase/decrease.

Take care,

Bert

"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday

Post #423539

Steve Jones - SSC Editor

Posted Monday, November 19, 2007 9:26 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

That calls for a part 2, Bert!
:D

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #423688

Bert Carles

Posted Monday, November 19, 2007 10:21 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, July 31, 2008 9:29 AM
Points: 1,800, Visits: 154

You're right. I really need to spend some time converting this over to SQL 2005 and expanding it beyond SQL Server.

Take care,

Bert

"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday

Post #423738

giorgio-459258

Posted Monday, November 19, 2007 10:23 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, January 03, 2011 9:45 AM
Points: 13, Visits: 49

That looks very nice BUT where is that Excel spreadsheet then? ;)

It would be really nice if you posted here also so we can have a look at final product... Smile

And to be honest I am not very good and Excel and all that graphs stuff so it would be rather nice to see how you're doing the whole "thing"

Cheers

Post #423739

Bert Carles

Posted Monday, November 19, 2007 10:40 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, July 31, 2008 9:29 AM
Points: 1,800, Visits: 154

I debated putting the Excel spreadsheet in the article. Ultimately, I decided not to since, once the raw data is in a table, you can present in pretty much any format you choose. I'm not very good with Excel either, but give me a few days, and after the holiday, I can post a "How I did it with Excel" follow up. I've also been working with a SQL 2005 equivalent. The internals are pretty much the same, but the presentation has much more potential with SSRS and SSAS...Perhaps another followup article?

This was my first stab at technical writing. I've already learned a great deal from your responses, thank you! I'll definitely try to be more detailed in the future.

Take care,

Bert

"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday

Post #423751

Garrick-249518

Posted Monday, November 19, 2007 8:50 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:51 PM
Points: 42, Visits: 612

I thought you can't query temp table as source in Transform Data task as stated here
[url=http://technet.microsoft.com/en-us/library/aa215269(SQL.80).aspx][/url]

When using temporary tables in the Transform Data task, the Data Driven Query task, or the Execute SQL task in DTS Designer, be aware that you cannot use a Transact-SQL statement or stored procedure that calls a temp table as your source.

Post #423875

Garrick-249518

Posted Monday, November 19, 2007 9:03 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:51 PM
Points: 42, Visits: 612

I mean at source tab in the Transform Data Task for DB Stats monitoring with the TSQL:

select * from tempdb.dbo.DayDBStat

Post #423876

Bert Carles

Posted Tuesday, November 20, 2007 5:27 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, July 31, 2008 9:29 AM
Points: 1,800, Visits: 154

Perhaps that restriction pertains to a #TEMP table? All I know is the DTS works as coded.

Take care,

Bert

"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday

Post #424006

« Prev Topic | Next Topic »

20 posts, Page 1 of 2

1 2 »»

Permissions