Viewing 15 posts - 331 through 345 (of 360 total)
Technically I dont see any stored procs under the programmability-->stored procedures folder of this database.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 26, 2011 at 12:55 pm
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 26, 2011 at 12:43 pm
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
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 26, 2011 at 12:25 pm
Thanks for the info Gail. The default log file path was incorrect. Its now upgraded to R2.
Thanks again everyone.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 24, 2011 at 2:15 pm
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 24, 2011 at 12:06 pm
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 14, 2011 at 5:16 pm
Sure...but how long should it usually take to analyze the workload for such a big trace...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 13, 2011 at 10:06 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 12, 2011 at 7:48 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 12, 2011 at 7:10 am
Is it a good practice to have the sql errorlog on a different drive...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 11, 2011 at 7:11 pm
Thanks for the info leeland...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 11, 2011 at 1:22 pm
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 11, 2011 at 12:54 pm
This is the ErrorLog...so if i restart the server...can i move that log to a different drive..
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 11, 2011 at 12:04 pm
I did include the clustered indexes
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 11, 2011 at 9:23 am
Yes I am..sorry for the delay..i thought i already replied
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 11, 2011 at 9:23 am
Viewing 15 posts - 331 through 345 (of 360 total)