Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Real-Time Tracking of Tempdb Utilization Through Reporting Services Expand / Collapse
Author
Message
Posted Saturday, March 14, 2009 1:58 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:53 AM
Points: 1,861, Visits: 3,599
Comments posted to this topic are about the item Real-Time Tracking of Tempdb Utilization Through Reporting Services

__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #675971
Posted Monday, March 16, 2009 5:23 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:53 AM
Points: 1,861, Visits: 3,599
Unfortunately, some of the figures are not clear enough. I will make sure I make them larger for the next article. :)

Please have a look at the supp. material, and, hopefully, that will make the discussion and figures clearer.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #676371
Posted Monday, March 16, 2009 1:05 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 4:08 PM
Points: 1,032, Visits: 287
Great article and I can already see many uses. One thing I did find is that the tSQL scripts to install the jobs assumes that the SA account has not been renamed. On All our servers we rename that account even though we use Windows Only Authentication. I simply edited the script and changed the SA account to the account we use.
Post #676852
Posted Monday, March 16, 2009 5:12 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:53 AM
Points: 1,861, Visits: 3,599
Rick Romack (3/16/2009)
Great article and I can already see many uses. One thing I did find is that the tSQL scripts to install the jobs assumes that the SA account has not been renamed. On All our servers we rename that account even though we use Windows Only Authentication. I simply edited the script and changed the SA account to the account we use.


Thank you and good point.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #677054
Posted Saturday, March 21, 2009 7:38 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 3:45 PM
Points: 536, Visits: 752
Thank you for the article and detailed solution. I had no idea that RS reports could be made so interactive using "Actions". Learning something every day!


Post #681007
Posted Sunday, March 22, 2009 5:40 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:53 AM
Points: 1,861, Visits: 3,599
mishaluba (3/21/2009)
Thank you for the article and detailed solution. I had no idea that RS reports could be made so interactive using "Actions". Learning something every day!


Thanks! Have a look at the new sql-2008 feature of performance data collection and the reports that ship with it. It will give you an even better idea on what is possible with Reporting Services.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #681055
Posted Monday, March 23, 2009 12:17 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 18, 2013 9:55 AM
Points: 13, Visits: 66
Thanks, for a Great article. I am trying to implement this on a test server and the report shows no data at all (Except the server name). When I run the stored procs by them selves I get data back. Any idea why the report is blank?
Post #681716
Posted Monday, March 23, 2009 12:26 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:53 AM
Points: 1,861, Visits: 3,599
scotta_miller (3/23/2009)
Thanks, for a Great article. I am trying to implement this on a test server and the report shows no data at all (Except the server name). When I run the stored procs by them selves I get data back. Any idea why the report is blank?


Thank you!

Are you running it on SQL-2008 Reporting Services? If yes, pls have a look at the bottom of the article (last figure), where I'm discussing a similar issue I was having when I migrated the app from SQL-2005. If you are running it on SQL-2005 SSRS, I will need more info to troubleshoot on.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #681730
Posted Monday, March 23, 2009 12:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 18, 2013 9:55 AM
Points: 13, Visits: 66
Reporting Services 2005 and all servers are SQL 2005.

I followed the doc included in the zip file. In reporting services The servernames Dataset returns the correct server name, I checked and the default servername is setup in the report parameters. I had to mod the Credentials setting to use windows authentication for the dymanic connection. I have tried setting all the datasets to use the AppDB.rds and statically assign the single server and still the report is blank. If I copy the Stored procs from the data tab and run them in SQL they return data .



EXEC [dbo].[rpt_Tempdb_Occurrences_LowestNumberUnallocatedExtentPages] @Top = 20 --- Returns 16 records

EXEC [dbo].[rpt_Tempdb_Occurrences_HighestNumberVersionStorePages] @Top = 20 --- Returns 20 records


EXEC [dbo].[rpt_Tempdb_Occurrences_HighestNumberMixedExtentPages] @Top = 20 --- Returns 20 records

I have created the Utility DB and I put the TempdbSpaceUsage_ServerNames table inside that DB, I have ran all the scripts to create the table and stored procs along with the JOB Script. I am not sure what I did wrong.

Please let me know what additional information you need???



Post #681741
Posted Monday, March 23, 2009 12:46 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:53 AM
Points: 1,861, Visits: 3,599
scotta_miller (3/23/2009)
Reporting Services 2005 and all servers are SQL 2005.

I followed the doc included in the zip file. In reporting services The servernames Dataset returns the correct server name, I checked and the default servername is setup in the report parameters. I had to mod the Credentials setting to use windows authentication for the dymanic connection. I have tried setting all the datasets to use the AppDB.rds and statically assign the single server and still the report is blank. If I copy the Stored procs from the data tab and run them in SQL they return data .



EXEC [dbo].[rpt_Tempdb_Occurrences_LowestNumberUnallocatedExtentPages] @Top = 20 --- Returns 16 records

EXEC [dbo].[rpt_Tempdb_Occurrences_HighestNumberVersionStorePages] @Top = 20 --- Returns 20 records


EXEC [dbo].[rpt_Tempdb_Occurrences_HighestNumberMixedExtentPages] @Top = 20 --- Returns 20 records

I have created the Utility DB and I put the TempdbSpaceUsage_ServerNames table inside that DB, I have ran all the scripts to create the table and stored procs along with the JOB Script. I am not sure what I did wrong.

Please let me know what additional information you need???





Hmm, I'm not sure what's wrong. I will have a look at the supp material I posted and retrace all the steps mentioned in the readme doc. I may have missed something.

Can you check whether the visible property is set to true for the chart?


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #681745
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse