August 27, 2009 at 10:11 am
My environment has SQL Server 2005 SP2. I want to have somehting that take care of the database, i mean how do i take care of the databases, keep them upto date. for your info i run DBCC CheckDB, DBCC UpdateUsage, DBCC Update stats every week.
once in two months i do rebuild/reorganise index. But even though i think that my databases might have somehting that make querries run slow. Can someone please help me out to take care of this issue?
Thanks
August 28, 2009 at 2:07 pm
if the performance slow then you need to may have to do lot of other things too. Analyse and optimise your query and check if they have they utilise the right indexes. You may have to increase the frequncy of index reorganising. Chk cpu and memory utilisation and i/o activity. there are monitoring softwares available from redgate and quest. You may wan tto see them
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply