Technically I dont see any stored procs under the programmability-->stored procedures folder of this database.

Yes...I can rebuild the indexes tonight...But the last time I rebuild the indexes (1 week back) the developers responded that there was no improvement in performance. Hence I went with...

Yes..They are heavily fragmented.

With the below conditions

avg_fragmentation_in_percent>=25

index_type_desc<>'HEAP'

page_count>25

I see the below results in AvgPageFragmentation column:

97.3684210526316

97.4930362116992

98.9464442493415

32.6492537313433

99.1079961771265

98.8682650167569

99.3258426966292

99.0776871230933

97.5475959987093

99.4094488188976

99.3220338983051

98.6636971046771

95.7746478873239

98.8826815642458

97.9591836734694

96.3414634146341

99.0182328190743

99.3698630136986

99.1575677007872

98.8620199146515

99.0721649484536

99.0215264187867

98.6111111111111

99.2857142857143

99.3220338983051

97.2972972972973

95.1965065502183

98.8695540087651

Thanks for the info Gail. The default log file path was incorrect. Its now upgraded to R2.

Thanks again everyone.

Hi,

I was trying to do an in place upgrade on my test environment but ended up with the following errors:

Error:

Wait on the Database Engine recovery handle failed. Check the SQL...

I stopped the analysis after your reply and traced the db. This time I only traced for an hour and the file is 1GB and started the DETA. In...

Sure...but how long should it usually take to analyze the workload for such a big trace...

When I executed the Exec Sp_Cycle_Errorlog a new errorlog was created and I was able to open the errorlog based on the timestamp through sql server error log viewer...it took...

Salom,

I was looking into the errorlog file that grew 35GB and all I see is just information messages without any errors and also there were only 26050 records of logs...

Is it a good practice to have the sql errorlog on a different drive...

Thanks for the info leeland...

Hi Leeland,

I ran the command Exec Sp_Cycle_Errorlog and restarted the sql server. Now I am copying the 35GB file to a different drive. I hope it releases the space on...

This is the ErrorLog...so if i restart the server...can i move that log to a different drive..

I did include the clustered indexes

Yes I am..sorry for the delay..i thought i already replied