"cross joins" we do a lot of cross joins involving 5 different tables a lot of times.

One other thing to note is the application is simple but the log seems to grow to 58g even though the data file itself is not even 300mb.

Any ideas why...

Interestingly enough now that i have set the max to 300mb the app services are running fine for 2 days now.

so the log db growth by 10% was the problem....

im not sure if this is related . The ldf file for the database is toooooooooooo huge. it is like 8207 MB !!!

anyways i have taken care of that. i...

Is there any kind of SQL logging i can setup to see if something unusual is happening at that time. it looks like there are no locks held but it...

As I mentioned before when this was happening

as soon as i ran an update command and let it finish then everything was back to normal.

one thing i noticed is...

on disk

one interesting thing i noticed. Update/Insert is locked for all the tables in that database at that time. But once i run an update query in the query analyzer and...