Blocking and Wait Statistics/Bottleneck Analysis Reports

Jul 18, 2011 at 10:44 AM
Edited Jul 18, 2011 at 11:10 AM

Hello

I am getting error 'The database doesn't have necessary data to run the report' while running Blocking and Wait Statistics/Bottleneck Analysis Reports. I also folled the below solution but still the error is coming. Please tell me where i am missing. I checked the collation in database.

name                 collation_name
TraceAnalysis     Latin1_General_CI_AS

Description

When I tried to run these 2 reports I get an error that 'The database doesn't have necessary data to run the report'. I later discovered that this is due to the fact that the collation set of the server I loaded the sqldiag data on was case sensitive. When I loaded this data onto a server where the server collation set was case insensitive, these reports started working flawlessly.
I also tried the below Sol but the tables below are missing in the database
  • tbl_Requests
  • tbl_blocking_chains
  • tbl_notableActiveQueries
  • Unable to view the Blocking and Wait Statistics OR Bottleneck Analysis reports or getting the error “Database doesn't have the necessary data to run this report”.

    The data for the above report is based on the SQL Server 2005/2008 Perf Stats script output depending on the version of the SQL instance that you are collecting data from. The file that normally has the data for the above reports to be generated will have the following naming convention: <ServerName>__SQL_2005_Perf_Stats_Startup.OUT or <ServerName>__SQL_2008_Perf_Stats_Startup.OUT. Ensure that this file has collected at least two snapshots of the outputs of the T-SQL queries present in the SQL Server 2005/2008 PerfStats script. The check that is done to report this error is to check if data is present in the following tables in the Nexus database:

    • tbl_Requests
    • tbl_blocking_chains
    • tbl_notableActiveQueries