SQL Server Performance

64-bit SQL 2K5 SP2

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by SQLDBAS, Apr 4, 2007.

  1. SQLDBAS New Member

    SQL 2K5 performing very badly than 2K . We have migrated SQL 2000 DB into SQL 2005 we are running same stored procs in 2005 they are taking more time than 2000.

    2k5 Server config:
    NUMA ENABLED
    4 CPUs (heper threaded)
    12 gb ram (10 gb for sql)..

    SP with dynamic sql ..

    Any inight ideas . Unfortunately we moved to prod.

    Thanks
  2. satya Moderator

    See this KBAhttp://support.microsoft.com/kb/920206 is applicable.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. joechang New Member

  4. SQLDBAS New Member

    Satya,
    I have reviewed that article yes that is the scenario. We have applied SP2 already so, we should have that hot fix am I right? How to find hot fixes are applied or not ? Our current version is 3052(SP2) . I do not have access to the server to check any other paramters. The IT group controls the servers..
  5. satya Moderator

    Can you test the hotfix in dev. environment>?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  6. bertcord New Member

    I had some problems moving to 2005 with table variables. I had to change several procs to use # tables instead.

    Change
    @TempDataset

    To
    #TempDataSet
  7. MohammedU New Member

    What kind of problems? Table variables were not performing better?

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  8. SQLDBAS New Member

    we haven't used table variables most of the are temp tables only. Really have no clue what to do? It is full of dynamic sqls.
    One more thing does anyone know how to turn off NUMA feature (at least of for SQL SERVER -T 825 or 828 something like that.. )
  9. satya Moderator

    It shouldn't be a problem in using temp tables as compared to SQL 2k and 2k5, specify what kind of issues you are having at preset.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page