64-bit SQL 2K5 SP2 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

64-bit SQL 2K5 SP2

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
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.
follow the steps below for both SQL 2000 and 2005 to get precise information http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19595
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..
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.
I had some problems moving to 2005 with table variables. I had to change several procs to use # tables instead. Change
@TempDataset To
#TempDataSet
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.
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.. )
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.
]]>