I upgraded my SQL 6.5 database to a SQL 7 database. I am now getting EXTREMELY poor performance. The application that accesses the server runs mostly stored procedures. I know that memory is handled much differently in 7.0, but SP’s that used to take milliseconds are now taking up to 30 seconds. The SP’s are called over and over and don’t seem to be staying in the procedure cache long enough. Any suggestions other then just adding more memory?
