all groups > sql server mseq > september 2003 >
You're in the

sql server mseq

group:

Reports running slow


Reports running slow Hienzs
9/18/2003 9:19:02 AM
sql server mseq:
Hi Thanks for reading.

One of my client uses a medical software called advantx.
We recently had to convert them to a new w2k Server
running sql 7 and active directory. Shortly After importing
the database (1 month) i noticed the database size
starting to grow at a rate that i thought to be way to
quick. from 560mb to over 1gig in three months. The client
has not increased in bis or are there any other factors to
explain the increase. Advantx thinks it to be normal. The
client is reporting longer and longer delays in generating
reports.

Avaliable Server and network resources are barely even
being touched. 12% peak processor usage during heavy load.

Server is 2.4 P4 with 1gig ram and 2 18gig seagate
barracuds in a mirroed set.

Reports running slow T.S.Ramesh
9/25/2003 1:21:22 AM
You just check whether sufficient Indexes are available.
If Sufficient indexes are there, then you rebuild the
indexes and see whether there is an Performance
improvement.

[quoted text, click to view]
AddThis Social Bookmark Button