Are these databases being restored from some bkp file? If its not, you can try to use the blocker script to monitor the commands running against your SQL Server with...

IgorMi (5/31/2013)

@sqlsurfing: Thank you for your links. I knew and read those articles/posts. I was looking to find something concretely for the VLFs' different size, and probably like...

Imagine that you want to know all inserts, delete's and updates that have been made into an specific table in certain period of time, or because a crash, or because...

Have a look at this topic:

http://www.sqlservercentral.com/Forums/Topic887666-146-1.aspx

Regards,

Hi!

I wrote a simple script one time that can help you on this question:

/*

TRACKING DML COMMANDS (INSERT,UPDATE,DELETE)

BY ANDRÉ CÉSAR RODRIGUES 13/09/2012 V1

*/

--FIRST YOU NEED TO CREATE IN SOME DATABASE THE...

Hi!

I work with more than 300 instances of SQL SERVER (all versions) and in all of it, we use this trace flag without problems 🙂

Regards,

Have a look at this article:

http://msdn.microsoft.com/en-us/library/ms143241.aspx

One note from the article:

Because the SQL Server on-disk storage format is the same in the 64-bit and 32-bit environments, a replication topology...

Did you see the last messages in sql server errorlog?

Did you have some kind of monitoring more specific for the sql server like the SQLDIAG? It could give you...

O.o Sorry

Try to read the following articles:

http://support.microsoft.com/kb/832674?wa=wsignin1.0

http://sql-blogs.com/2012/07/09/sql-server-how-can-you-say-its-memory-pressure/

Hi!

In your case, to the users databases i'll try to start with just one data file and try to start and maintain just one file for the transaction log,...