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?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]