Joseph (3/12/2009)

---

Hi Matt - i checked most of the indexes, the avg_fragment_size_in_pages is 1, 1.5,1.383 like this.. can you tell me what does that mean...is there any certain point to...

For what it's worth, it's not just the duration of the rebuild that matters. You are also impacting the server by locking the index for the duration (offline rebuild)...

You should also look at avg_fragment_size_in_pages - the higher the better. Because SQL reads extents (8 pages) a low value can indicate that more extents are being read than...

I'm confused, when you say you are failing to connect are you talking about a login error, or a failure to connect to the server?

You indicated that you can...

Simple recovery mode logs everything that bulk-logged mode would, the difference is that it doesn't require a log backup to free space for reuse. The log file may still...

I can't think of any good way to do this. You could profile all statements over a period and parse them for temp table/variable usage, and you could profile...

Can you ping the db server using that DNS from the web server? If so, is it showing the expected ip address?

Ah, my mistake. Just as a reference, I like to allocate enough free space for at least a year on my databases - apart from lower fragmentation it's easier...

1MB is the default.

20MB for autogrowth is fine, you can set it to less if you wish as SQL will autogrow as many times as necessary until it runs out...

Without seeing the table and index DDL for the communication table it is hard to say exactly what the problem is. Comm_LeadId is in a nonclustered index, you may...

You can choose whether to have SQL files grow automatically, either by a percentage or a fixed amount. Best practice is to monitor file sizes and allocate more space...

Unfortunately it's not quite that simple ... each row has other information associated with it - a null bitmap for example. If your clustered index is not unique then...

Roy : I was just referring to these errors -

SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some...

You can also use an after trigger (the default type), which is more common for auditing as it adds to the original modification statement instead of replacing it.

The...

Dropping a database flushes the caches for that database - the information can no longer be used. Those messages are normal.