Post reply

SQL Server 2005 Performance Dashboard Using SSRS

  • December 3, 2010 at 5:13 pm

    #1258697

    Then, there shouldn't be any changes to the code. Those post of mine are only for SQL Server 2008 I don't have SQL Server 2005 to test the code. Sorry my posts weren't not in much help to you.

    btw, what's the error you get ?

    Good Luck,

    Bala.

  • December 3, 2010 at 5:17 pm

    #1258698

    Thanks, Bala. The Error that I'm getting is as follows:

    Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27

    'object_schema_name' is not a recognized built-in function name.

    Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42

    Incorrect syntax near the keyword 'as'.

    Msg 15151, Level 16, State 1, Line 1

    Cannot find the object 'usp_GetPageDetails', because it does not exist or you do not have permission.

    The first error seems to infer that I don't have SP2 installed... which I do have installed.

    Do you think that reapplying SP2 might fix this issue?

  • December 3, 2010 at 5:43 pm

    #1258702

    You are right. try to run the sp2 upgrade. This post answers your question.

    update.

    Best,

    Bala

  • August 7, 2013 at 6:48 pm

    #1639599

    Check your data source and that permission are applied

  • October 20, 2015 at 5:37 am

    #1834320

    Sir,

    This will give 24 hours history of CPU?

    Thanks,

    Raj

  • October 20, 2015 at 7:07 am

    #1834349

    The graph only displays a 15 minute window.

  • October 8, 2019 at 5:27 pm

    #3687097

    Just a quick update...Performance Dashboard is still alive and well.  Here's a great article on installing the latest version from Pinal Dave: https://blog.sqlauthority.com/2014/09/22/sql-server-ssms-performance-dashboard-installation-and-configuration/

     

Viewing 7 posts - 46 through 51 (of 51 total)

You must be logged in to reply to this topic. Login to reply