I have been using ms sql 2005 for a while now. But recently one of my server has became too slow. I have not added neither changed anything on that server. It's a HP 380 G6 with 32GB ram and 2 processors 2.26ghz each.
kindly help.
TOMASO 0 Newbie Poster
pclfw 23 Junior Poster
How fragmented are the indexes? DBCC REINDEX is your friend.
Fragmented disks, these can also kill performance. Are the disks nearly full?
How full is the Db? can you archive records to reduce the number of rows in the table(s)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.