Use of temp tables within SQL Tasks - make server slow?

[Spidy6123]

Hi,
I'm really trying to solve why my server is performing slowly after I run this SSIS package.

I'm wondering if this is the cause, amongst other tasks, basically I have a large SQL task that produces a number of temp tables in order to produce one large table with a join insert. I then drop the temp tables.

After running this SSIS, the whole server runs slowly..
I'm wondering, will the use of temp tables make the server crawl even after they are dropped?

 

[mrdenny]

It could, but only for a short period of time. Once SQL recovers the space which the temp tables were using you should see the speed recover.

What does perfmon say when you monitor the disks performance? Is your tempdb set to autoshrink? What does the CPU look like when the SQL Server is running slow?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Spidy6123]

well aparently the cpu distribution in not configured correctly...so Im told

Im fairly new to this whole MS SQL management studio.. could u possibly direct as to where I can find this information that u mention.. I have full access to the server...

I mean.. I run pretty complicated scripts for the purposes that my job requires... Im just not a DBA... but Im interested in learning.. I really dont mean to be a bother

any advice is appreciated..thanks in advance buddy

 

[mrdenny]

Disk performance and CPU performance can be monitored in the Performance Monitor. Tempdb database settings can be checked by right clicking on the tempdb database and selecting properties.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com