November 24, 2011 at 9:46 pm
Environment is like
OS :Windows 2000 SP4 Enterprise edition
memory : 8GB
SQL Server : MSSQL2000 SP1 Enterprise edition
Data & Log files are on same drive
In this environment I have checked logs, there are no long running jobs/queries. This environment is having performance issue.
My solution for P.T
-> Service Pack SP4 apply to SQL Server
-> Change of Data & log file location
-> Index rebuilding
I am getting 4 hours of downtime as Db size is 26 GB
can you suggest me exact steps. And step by step index rebuilding process.
Sagar Sonawane
** Every DBA has his day!!:cool:
November 25, 2011 at 12:11 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1211786-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply