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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy