SQL server performance tuning

[robsuttonjr]

I am using MS VB to access data on SQL Server 7. The SQL server is running on a clone with a Pentium 3 550 with 512 meg ram and IDE raid drives. We are experiencing timeouts when accessing the data and more than a few users slow the response down dramatically. Has anyone been through this before? What is the best solution? Does simply buying the fastest CPU make all the difference? Are there other SQL server settings that could help or is this just a hardware/network issue? Any thoughts on how we could speed up performance with around 10 users accessing the SQL server would be appreciated!

 

[jplaz]

Hello I am DBA SQL Server, first you would have to configure the SQL Server, send the result of the execution of stored procedure SP_CONFIGURE, it is important that timeouts, and the size of the Net packets, are correct.
The Querys give back many data?

 

[tlbroadbent]

ALWAYS analyze application design first to solve performance problems. I can guarantee that merely upgrading hardware without giving proper attention to query design, table design, indexing, etc. will produce no significant performance improvements.

See the following for links to articles on SQL Server Performance tuning.

http://tlbroadbent.home.attbi.com/sql_and_access/sql_performance.htm

Please let me know if you find any broken links or have additional resources that I should add. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.