Thanks.

Unfortunately we don't have a "spare" server to do a "round robin"..:-(

What if the client doesn't know the instance name, just connects to the correct oprt? Can it cause problems?

Thank...

RPC completed also needed in the trace, sorry, I missed somehow

A transaction is left open obviously.

I don't know the application, but a good candidate is a timeout.

-The connection was running a long query

-It was timed out

-The connectoin was reused...

Jeetendra (5/15/2009)

---

Hi Gurus,

I have a small doubt about the Log shipping on SQL Server 2005 EE (SP3) as below:-

Currently my Production Server is having a DB of around 200GB of...

gaganks (5/13/2009)

---

Hi All,

I have a Cluster Setup for sqlserver 2005 enterprise etd.I have 8 Gigs.

Now, Can some one help to find what is the Memory Used by the Processes. (What...

Suresh B. (5/15/2009)

---

A single Log files is sequential....

I'd recommend to run a trace, and look for autogrow events.

Paralelly start a script which runs in every minutes, and writs out the inputbuffer of each spid>49, plus the last...

Please try to focus on this:

How can it happen that

-it (DBCC SQLPERF(LOGSPACE)) says 26% (=500MB) used AFTER a tran log backup, while minimal (<100KB) transaction were processed since

-Only one...

Thank you,

Of course I know why the LOG was grown.

But how can it happen that

-it says 26% (=500MB) used AFTER a tran log backup, while minimal transaction were processed...