I just found a couple entries in my cluster error log i think it's related to disk failures.....not quite sure.

334:8f8.07/20[11:57:31.314](000334) INFO [FM] FmpRmOfflineResource: RmOffline() for a13f3122-5c69-46ed-9b8a-f453754fe090 returned error 997

334:8f8.07/20[11:57:31.314](035307) INFO...

Hi asranantha,

Please clarify the term "join" you only can join tables when both tables has the same id's using the statement

INNER JOIN Table1.ID ON Table2.ID, but if you need...

sturner (1/23/2012)

---

some of it depends upon the nature of the application running on it (it is using some CLR code that does external access?). Other than that it should be...

Steve Jones - SSC Editor (1/23/2012)

---

If you use the Configuration Manager, it should assign all rights SQL Server needs to the account. If you've moved anything, or you use non-standard...

stuart@leaf-node (1/15/2012)

---

Do you mean you want to reduce it back to it's 'starting' size? Or do you want to reduce it's starting size?

A restart of the SQL Instance will reset...

Hi guys,

Two days ago i shrank the log and i could reclaim some space, after that i noticed that the log transaction backup was reduced dramatically almost 90% percent (past...

I ran the last query without any results 🙁 still not idea about what is causing the size of transaction log backup.

Ok, got it, i'm going to do that and back with more details, thanks

I was asking to the owner of the application and he's not aware of any heavy workload in the server of massive deletion, probably it's happening like you said...

No, david unfortunately we dont have any 3rd vendor like redgate 🙁

Sorry i noticed your replay 🙂

ok let me google it

One more question Sir, what's the interpretation for the operation and context columns retrieved from the query?

I ran it but how can i use those results, because i saw:

e.g.

dbo.TransactionLog.PK_TransactionLogLOP_MODIFY_ROWLCX_TEXT_MIX

dbo.TransactionLog.PK_TransactionLogLOP_MODIFY_ROWLCX_TEXT_TREE

dbo.TransactionLog.PK_TransactionLogLOP_SET_BITSLCX_GAM

dbo.TransactionLog.PK_TransactionLogLOP_SET_BITSLCX_IAM

sys.sysallocunits.clustLOP_COUNT_DELTALCX_CLUSTERED

Great Sir, let me try it and come back with more details.

Thanks

So, if i'm take a look into the stats dates l'm going to have a better idea about what happened?

I was checking jobs but nothing comes up, any idea how can i know if indexes were rebuild or activity related with high transactional activity.

Thanks