Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
shishirkhandekar
Starting Member
23 Posts |
Posted - 2011-04-27 : 11:51:37
|
Hello,We have two pretty complex queries that involve sorting/ordering. Will provide details if required. We were running into timeout issues on these queries. While we do have opportunities to improve them, the interesting part was, in the trace events that we captured to investigate the issue, We notice in the SQL Trace that once the query begins, I see a SQL Transaction event with ObjectName as either GarbageCollection or GhostCleanupTask. This continues for about 30 seconds when the query times out due to the default timeout of the Command object.The sequence of events is:SP Statement Starting : Complex querySQL Transaction: sort_initSQL Transaction: TVQuerySQL Transaction: GarbageCollection (We use filestream feature)SQL Transaction: GhostCleanupTaskCan anyone explain why, for a very complex query, the sort_init would kick in the GC and GCTask ?Appreciate any help...ThanksShishir Khandekar |
|
shishirkhandekar
Starting Member
23 Posts |
Posted - 2011-04-27 : 16:28:55
|
One thing that I forgot to mention was that this happens only when this stored procedure is called from the application tier (.net) and not thru SSMS. We use SQL 2008 R2 RTM, Express Edition. |
|
|
davidfu
Starting Member
1 Post |
Posted - 2013-09-04 : 23:06:19
|
I have same problem now, and want to know how did you solve it? thanks. |
|
|
|
|
|