Thanks for the information. I will start playing with FillFactor value for those indexes which are being fragmented frequently and see how it goes.

We do not have any clusters yet. However we are planning to set it up. Hopefully it should be after upgrading to R2.

Is this a free upgrade or need to...

There is no fillfactor specified. So, I assume there is no room. Do you suggest fillfactor value of 80 or so?

I do not have AutoShrink on. However, i have performed ShrinDB once. What happened is we migrated 8 years of data from some other system to our database. I then...

I do not know whether the application is doing range match or seeks. Do you remember the DMV name by chance?

I prefer LiteSpeed over SQL native compression. I have been using this for couple of my projects. LiteSpeed provides various compressions levels to use. I went with default which is...

Thanks man. I will use the SORT_IN_TEMPDB option while rebuilding indexes. I hope it will reduce the transaction log space. Yes, I do have enough space for TempDB.

Don't understand the...

Perfect. I will implement Mirroring then. I'm still thinking of doing Index Maintenanc once a week as opposed to it daily. However, i will update statistics daily though.

What do you...

I will look into that. On a side note, do you recommend us to go with Database Mirroring (Async) Vs. Log Shipping. We have no requirement for automatic failover. My...

I skip running this job some days due to planned downtime or for other reasons. I have not heard that application has performance issues next day. So, i assume i...

Thanks for you input. Currently, I'm rebuilding index only if the fragmentation is more than 40%.

I'm performing reorg on the index if the fragmentation is between 10 and 40.

Do...

From your responses so far,

I will add make the max. memory change and add the sql service account to "lock pages in memory" option. Hopefully these two changes will fix...

Thanks for the query. It is very helpful. Here are the values of the following 2 counters:

Page life expectance: 22804

Buffer cache hit ratio: 6580

What do these...

I have not applied "Lock pages in memory" option yet but planning to do this along with this change. Hopefully it should increase the performance of my SQL Server.

How can i moitor PLE (page life expectancy)? I'm thinking of giving 12GB to SQL Server and leave rest 4 GB to OS and other applications.

Is there any draw...