CHECKDB came clean.

You can use the copy_only option to take Log backup without breaking the LSN chain.

I believe the adhoc backup will have continuing LSN and placing that in log shipping folder...

Suresh B. (8/9/2012)

---

1. Checkpoint writes dirty pages to disk. Not individual rows.

a. Did not understand the question. Eighter rollback or commit can happen. Not both.

2. When the server starts up...

Hi Achtang,

Again you have to restore the new master with your master backup file otherwise it wont read your user databases it will all greyed as ur new master have...

Check the email from address that will give you a good idea from where its generation if its giving alert through email.

Do you have 2005 Client??

Connect using that, i mean 2005 SSMS check the properties of the server-->memory it will show you the max memory configured for the server.

Sorry Gail,

Cant download from here..

Will read those and get back to you.

I saw only one page and went through that.

"We spend much of our working life helping solve SQL Server-related performance problems, hands-on, during consulting, or on online forums. We've seen...

Thanks Gail.

Can you please guide me what exactly i need to do i ruled out CPU bottleneck as i found the CPU usage below 30% most of the times.

User connection...

That was informative..Till now i thought table doent having clustered or non-clustered index is called heap..

Derrick Smith (9/28/2011)

---

Just a note here, the active transaction may not be in tempdb. It's most likely in your app database and is just using tempdb and therefore wont show...

Steve Jones - SSC Editor (9/28/2011)

---

You can close some connections and those objects will drop their tempdb space. Or cancel the transactions.

You could try adding 5MB to the existing...

Steve Jones - SSC Editor (9/28/2011)

---

You'll need to grow tempdb to gain a little space for the growth operation.

You can restart SQL Server as well to clear the tempdb db...

its the same table,same number or rows,same data..

But if thats the case tehn it should not run fast next day morning right??

It is like everyday morning the query executes in seconds and in afternoon its taking hours..Actually...