Thanks for the info Joe, The suggestions didn't help so it looks like I'm going to have to roll it back to 6.3 Can't have the CEO trying to use the application and the only explanation I have for why it's taking 5x longer is because we upgraded lol. -------------
Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, October 18, 2007 3:54 PM To: arslist@ARSLIST.ORG Subject: Re: 6.3 vs 7.0.1 slowness ** If 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: arslist@ARSLIST.ORG 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] <mailto:[EMAIL PROTECTED]> __20060125_______________________This posting was submitted with HTML in it___ This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
