Thanks Gail for the reply.

We don't have any Extended events or trace running. Was check the sysprocesses only.

Please advise what to check on this.

You can connect but wont able to see\use the features of other editions..

Thanks cunningham.

The processes was basically from application server.

Alexander Suprun (9/24/2014)

---

You should have asked that question when your...

I am trying to run the below script

dbcc shrinkfile ('tempdata',emptyfile)

go

ALTER DATABASE [tempdb] REMOVE FILE [tempdata]

GO

we killed oldest active transaction and suddenly all data files got 99% free space and we were able to release more than 120GB.

Can any experts here help me find why...

Perry Whittle (9/22/2014)

---

Ratheesh.K.Nair (9/22/2014)

---

Hi Experts,

We are getting below error in our secondary replica.

The mirror database, "Financials", has insufficient transaction log data to preserve the log backup chain of the principal...

jacksonandrew321 (9/22/2014)

---

As for some extent I know, u need to take full backup and a log backup as well on principal instance. Copy full and log backup from principal to...

Grant Fritchey (9/12/2014)

---

You can also use DBCC FREEPROCCACHE and pass it the plan handle of the plan you want removed from cache.

NOTE: If you don't pass it a plan...

Thanks Gail..

Can you help me on the other ways to test the performance?

Thanks a lot Gail.

Developers want to test performance of a particular procedure and requested to run DBCC DROPCLEANBUFFERS & DBCC FLUSHPROCINDB,is it neccessary to ran these. SP_RECOMPILE is enough to...

Gail ,

Can you please guide me on how to find the root cause of log growth?

Thanks Gail,

After almost 16 hours DB is up.

Able to shrink the log files and Now the drive is having 614GB free space.

Thanks a lot Gail..You are awesome..

Below error are logged in error log before starting recovery.

Database ABC has more than 1000 virtual log files which is excessive. Too many virtual log...

GilaMonster (9/11/2014)

---

Clear up some space on D (move other DB's logs or allocate more space) and wait.

What error messages are there in the error log? A full log should not...