Good article, thanks for the summary.

The biggest issues I've encountered, save for a server side trace, is catching the originating hostname for the incoming connection. To me this is a...

As much as I am against necro'n a thread, this topic kept coming up on related searches so I wanted to add a link to relevant information.

http://artofsql.net/dbcc-log-in-sql-2000-part-1/[/url]

Hi Luke and thanks for the reply.

The SmartPlacement tries to re-arrange the entire disk in addition to making the files contiguous. It will try to put the most accessed files...

Any experience on this matter is welcome. If you don't defrag at all I'd like to hear your thoughts.

Thats the best lead yet, thanks!

Anyone else witness stopping a service and then not being able to restart it because it never truly stopped?

"I suggest to trace through SQL Profiler. You will see what SQL statements are triggered from Access." -Terry

Good suggestion, we had run it through a trace and found that the...

You're right about RAID10 being the way to go.

Thanks Jo

-Z