In My company using sql server2000 for ERP product. Crystal also using in the same database.
Around 60 reports in the crystal. Using ASP to getting the reports.
Using frame in the html pages.
Aroung 32 users are connecting in the server. Opening the crystal report
its talking more than 5 mints. pl suggest me to get rid of from this problem.
Server pIV-2 GB ram, 2.6 ghz speed.
40 gb hdd.
Server is login server(DHCP) for network and shared folders also in this server, users accesing the shared folder.
ANY THING TO DO IN THE SQL SERVER TO MAKE UP SPEED.
Thanks & Regards