http://chucksblog.typepad.com/chucks_blog/2006/12/benchmarketing_.html

SAT_SQL (6/29/2009)

---

We have the problem , when 5 of us using the same local server called "sw-19", we the utlization of sqlserver is becoming to 70% ,...

< rubs hands together >

Have you done IO stress tests on that?

And...

In my opinion there's only one case where you may not want this turned on.

If the same drive that's used for the SQL data files also contains (or did contain)...

Hi Sir ,

Please help me !!

I am trying to optimize one store procedure

The problem is when

I use EXEC store procedure , i am seeing table scan in execution plan

but when...

GSquared (6/30/2009)

---

No more waiting required. Let me know...

:hehe:

Looks like totally ignored to me.

That's the first of a series of three. Did you read the others?

Again, if you want specific help, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Please read through this - Managing Transaction Logs[/url]

If it happens again, query sys.processes and see what the wait_types are.

I suspect parameter sniffing of one form or another. http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

If you want specific help, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Begins and ends just denote blocks of code in a stored proc.

CREATE PROCEDURE BeginEnd

AS

SELECT 'Before Begin'

BEGIN

SELECT 'Number 1'

END

BEGIN

SELECT 'Number 2'

END

BEGIN

SELECT 'Number 3'

END

SELECT 'After end'

GO

EXEC BeginEnd

Signalling the end of the batch and the end of the stored procedure. If you don't put that there, the GRANT EXEC...

YSLGuru (6/30/2009)

---

The only problem now is that the accounting app is now getting messages from SQL Server it doesn't know what to do with and so it thriws them up...