Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
martymsyr
Starting Member
2 Posts |
 Posted - 2007-12-11 : 23:57:35
|
| We are relatively new to the setup, configuration and use of MS SQL. We are currently using MS SQL2000, Our sql application performance as become very slow. I am trying to find some basic "beginner" steps that I can take to improve performance and quicker lookups. Some of the things I have heard but I am not sure what they mean or how to do them are: 1) Locate SQL Temp files onto another drive, will this help and which/what temp files2) should i put the mdf ldf files onto a separate drive?3) Put Sql server program on a seperate drive?4) our ldf file size is about 2GB is that OK any suggestionsAny other basic suggestions to improve performance and throughput is appreciatedwww.accellus.com |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-12-12 : 00:48:51
|
| are there cursors in your code?VinodEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-12-12 : 01:04:00
|
if you don't know where the bottleneck is, you need to profile. it could be something as simple as creating an index would fix your problems.do you know how to use Profiler?
elsasoft.org |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-12-12 : 01:06:43
|
| Dear Jezmine,please provide us the concept how to use profilerVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
|
|
|
Small SQL shop - SQL config for performance