| Author |
Topic |
|
bhman79
Starting Member
10 Posts |
 Posted - 2011-06-13 : 09:02:17
|
| We are running SQL 2000 and only have up to 12 users connected at one time. The front end was written in Clarion. The system is very slow most of the time. Everything from going to screen to screen and especially reporting. I am already running the maintenance plan to rebuild indexes, and the log file is being shrunk on a regular basis. Any other suggestions on how to improve our performance?? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-13 : 10:15:56
|
| Stop shrinking database or log would be a good start. That hinders performance, doesn't help it.--Gail ShawSQL Server MVP |
 |
|
|
bhman79
Starting Member
10 Posts |
Posted - 2011-06-13 : 10:41:30
|
| Our log file had grown to 10 times the size of the database. Its not a good idea to keep that trimmed back?? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-13 : 10:51:01
|
| It's better to back the log up regularly to keep it from growing to that size. How often are you backing it up? |
|
|
|
bhman79
Starting Member
10 Posts |
Posted - 2011-06-13 : 11:11:11
|
| We backup the database nightly, but it looks like it doesn't back up the transaction log. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-13 : 11:23:56
|
| Full backups do not truncate the transaction log. Please read through this: [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-06-13 : 14:53:58
|
| As well as managing your log backups - investigate your queries , are they running efficiently? Are you getting any queries that are very slow ?Check the query plans.Has the system always been slow or is it a recent change?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
bhman79
Starting Member
10 Posts |
Posted - 2011-06-13 : 15:09:36
|
quote:
Originally posted by jackv
As well as managing your log backups - investigate your queries , are they running efficiently? Are you getting any queries that are very slow ?Check the query plans.Has the system always been slow or is it a recent change?Jack Vamvas--------------------http://www.sqlserver-dba.com
|
|
|
|
bhman79
Starting Member
10 Posts |
Posted - 2011-06-13 : 15:11:11
|
| I haven't been here very long, but I'm told that its gradually gotten slower over time. Whats the best way to check the query's? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-13 : 15:46:01
|
| http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/--Gail ShawSQL Server MVP |
|
|
|
|
Performance