If you concern about the size of the log file, consider using one of the following methods to prevent the transaction log files from growing unexpectedly:

1. Back up the transaction...

I had seen the article before along with various others (that were more relevant for this circumstance).

The whole point though with the Lock Pages in memory for 64 bit enterprise...

No it is Enterprise (I thought I put that somewhere - sorry!)

Will the minimum server memory setting lock it in and prevent it from shrinking?

Culprit discovered...One of the overnight backup processes for that server overran and finished at the same time the system cache stopped filling up. So there was the offender!

I am going...

Thanks. Well typically the massive bursts in System Cache have now subsided with the server side trace and perfmon in place even thought he big job is still chugging along...

Thanks for the advice. I need a bit more help though - If I run a server side trace how will I be able to correlate the system cache on...

I will get them to check.

In order to resolve this, I am trying to answer my own questions through investigations I have made. If someone could confirm I am correct...

Good idea, but still - Inability to "select all" or "map multiples"? Poor show! :hehe:

Going back to this one.

It turns out the machine isn't liking users from our other domain. Our support guys are adiment that the trust is set up properly. I can...

I've got all the usual suspects - StmtCompleted, BatchCompleted. The started ones, Execution plans. Its throwing up nothing at all for this spid other than cacheremoves.

Good call on the file...

The user was tied into BUILTIN\Administrators as he is in the local admin group on the domain. I took sysadmin off of BUILTIN\Administrators and it allowed him to work. I...

Sorry for bumping this but I am having the exact same issue. Running a Delete Directory Contents task - however in my case it fails in both BIDS and through...

I resolved this. Sadly I did 2 fixes on the same night so not sure which fixed it.

Firstly, I added the db settings mentioned previously before the update stats job...

Thanks everyone for the advice and positive feedback! Made me feel better anyway!

I can see why so many SQL Server workers take up blogging!

I'll be using all the advice in...

Can anyone help me understand how the 63 hidden sectors and the alignment calculations above come together? I have read the MS White papers but can't get my head around...