Are you sure that the sleeping sessions come from IIS?

Are these sessions blocking other sessions? Why are you concerned about them?

Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic520315-338-1.aspx

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic520331-148-1.aspx

The remote server or the driver for the linked server doesn't allow remote transactions.

It's nothing to do with the proc rewrite. Check the linked server settings or check with the...

Profiler or a server side trace.

If you want to see the queries within the procs, you want the sp:StmtCompleted event.

Be aware that if your server is busy the trace...

Depends on the queries that use that table. There's no hard rule.

You should have a clustered index. You should have enough nonclustered indexes on different columns that the frequently run...

Do you have a backup of that database?

What's your question?

Main difference between 2000 and 2005 is that in 2005 you can alse add columns as INCLUDE columns insted of as part of the key. Makes it a lot easier...

Ah. A form of serverside trace.

I thought for a moment that I'd missed a feature like 2005's default trace. :hehe:

What ways are impossible?

Be patient. We're all volunteers here. We're not paid to answer forum questions.

<eyes glaze over> Right....

In addition to Grant's comments...

You have a lot of branching logic within the proc (if.. else...).

That kind of thing tends to lead to sub-optimal execution plans,...

Grant Fritchey (6/19/2008)

---

I'd have to hit the 2000 books online, but you might be able query the procedure cache (I know exactly how in 2005, but it's different). Try looking...

Do you have a backup of msdb?

If you look in the SQL log file (the error log), are there any entries that indicate why the database is suspect?

Bookmark lookups occur when SQL uses a nonclustered index to evaluate the rows required for a query. If the nonclustered index does not contain all the columns needed for the...