Post reply

SSMS extremely slow on Open Table

  • September 18, 2009 at 4:44 am

    #1055486

    I had a very similar issues with a Dev's PC.

    I updated to the latest graphics driver and it seemed to be a little quicker (not perfect)!

  • September 18, 2009 at 4:53 am

    #1055490

    try a lower resolution @ lower bits as well....

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • September 18, 2009 at 5:06 am

    #1055496

    @Henrico.

    I tried a another resolution: 16 bits in stead of 32 bits. Maybe it's a bit faster, but still very slow. :crying:

  • September 18, 2009 at 5:08 am

    #1055500

    @ sql_lock:

    Thank you for your suggestion.

    I'll try to update to the latest graphics driver.

  • September 18, 2009 at 5:10 am

    #1055502

    Run SQL BPA maybe you'll get some answers there? I know I have.

    Sounds like an underlying problem, and directly related to your hardware or drivers?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • September 18, 2009 at 5:41 am

    #1055516

    Henrico Bekker

    Run SQL BPA.

    Sorry, I don't know what you mean by BPA, please could you explain?

  • September 18, 2009 at 5:46 am

    #1055518

    BPA = Best Practise Analyzer

    Download Here:

    http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en

    This will evaluate your SQL Server and provide a very detailed report on all recommendations (as per Microsoft)

    Show's vulnerabilities, issues with growth etc...

    Handly tool for all DBA's on basic troubleshooting...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • September 18, 2009 at 7:04 am

    #1055563

    Thanks Henrico,

    I am a developer, not a DBA, that's why I didn't know what a BPA stands for 😉

  • September 23, 2009 at 7:28 am

    #1057490

    Henk Schreij (9/18/2009)

    @ sql_lock:

    I'll try to update to the latest graphics driver.

    I Updated the Intel 82915G driver (from the year 2004) to the latest version (2007).

    And now is "Open Table" fast again 🙂

    Thank you !

  • September 23, 2009 at 9:02 am

    #1057575

    Henk Schreij (9/23/2009)

    Henk Schreij (9/18/2009)

    @ sql_lock:

    I'll try to update to the latest graphics driver.

    I Updated the Intel 82915G driver (from the year 2004) to the latest version (2007).

    And now is "Open Table" fast again 🙂

    Thank you !

    No prob... 🙂

Viewing 10 posts - 1 through 11 (of 11 total)

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