MessageIf you have just performed an upgrade, you might want to flush your transaction logs. When transaction logs are full it usually slows down the response from the database. Log into the SQL Query Analyzer or any other SQL client tool you have that you run your SQL transactions when necessary.
Then run the following to flush your transaction logs assuming the name of your AR System database is ARSystem Backup log ARSystem with truncate_only; This would truncate your transaction logs. After this as an optional step, you might want to shrink the database too and then resize both the data and log files for the ARSystem database. Give it sufficient free space for the data file, and keep the transaction log file to about at least half the size of the log files. (You can perform the shrink and the resize operations using the MS-SQL Enterprise manager) Cheers Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Wheeler, Dylan Sent: Thursday, October 18, 2007 6:28 PM To: [email protected] Subject: 6.3 vs 7.0.1 slowness ** Does 7x require a hefty server? I have a server that we upgraded from 6.3 to 7.0.1. One of my refreshes was a bit lagging before but now it is a lot slower. It's a Dual 2.8G Xeon HT box with 4G of RAM, local MS SQL install. Right now it's pretty much a development box with only 1 or 2 people connecting to it. I have a display only form on there that has a table. The table refresh on 6.3 patch 21 took about 2-3 minutes. That was expected though because of all I was doing with it. Building a pretty hefty query and then displaying about 2500 records with no paging. With the box now on 7.0.1 patch 4 with the same code, same amount of records, the table refresh takes about 15 minutes. I also notice that if I use the 7.0.1 or 7.1 admin and client tool to connect to my 6.3 boxes it takes a lot longer to perform things then with my 6.3 tools. Curious if it's just me or if others are seeing this as well. ------------- Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.15.0/1077 - Release Date: 10/18/2007 9:54 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
