SQL Server Performance Forum – Threads Archive
temporary tables
Hi guys,i’ve notice a decrease in performance when i frequently create and drop temporary tables in SQL Server 2000. Is this a bug in SQL 2000 or anthing else???
AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS
but it was mentioned that use temporary table instead of cursor and table variables http://www.sqlservercentral.com/columnists/dasanka/temptablesinsqlserver.asp
Underlying reason might well be that the file size and file growth settings for tempdb are inadequate. Increase the initial file size and/or reduce the growth factor (if set in %).
Yep i agree but there i think that when you have many Temp tables , i does affect the server performance. I am not sure whether it is because i drop an recreate the table that the server slow down!!!!!!! AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS
Linkshttp://www.windowsitpro.com/SQLServer/Article/ArticleID/46771/SQLServer_46771.html andhttp://www.sql-server-performance.com/rd_temp_tables.asp for information, sometimes table variables are handy as per this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;305977 link. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Keep the tempdb databse in a different drive if you are using it frequently and then check for performance.
True and if you’re getting performance hit whenever you’re dealing with TEMPDB then ensure to manage it from a seprate location with nominal sizes. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Keep tempdb at a reasonable size and look through tips here on this site. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
Ok, i will try to keep the size moderate and try to keep it separetely AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS
]]>