December 10, 2009 at 12:38 pm
I have written one stroed procedure which internally uses some views to fetch data but due to some reason when we run it, tempdb starts growing...can somebody give some light on it...The SP expect to return 500k rows
December 10, 2009 at 12:54 pm
Are you using Temp tables and also performing any sorting operations ?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 10, 2009 at 3:32 pm
It sounds like you are either writing to tempdb in the stored procedure, or the underlying views you are accessing are using tempdb in some way. Try running Profiler and run the sp again and see what you get.
Joie Andrew
"Since 1982"
December 10, 2009 at 9:37 pm
Post the code, and we can better help you.
Joie and Bru have given some suggestions that could be helpful, but they are shots in the dark without the code.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply