SQL Server setings.

[AdoSun]

I’m running a SQL statement, which takes a lot of time to execute. Because of this the entire SQL server is dead. If I’m trying to run other SQL statements this are severally delayed. And this is no god. Can I set some priority of the statements that I execute, or some SQL Server parameters that can improve this behavior?
The SQL Server system has the fallowing configuration:
OS: MS Windows NT 4.0
Dual processor 800 MHZ each;
512 MB RAM
one 20 GB SCSI and one 60 GB HDD
and MS SQL SERVER 7.0

 

[tlbroadbent]

SQL Server doesn't allow setting of priorities for individual queries. Generally speaking, you can't fix most performance problems by tweaking the SQL Server settings or modifying the hardware.

The first step in improving performance is always to analyze the application. In this case try to determine why the query is running so long and consuming so much resource. Query design and poor indexes are generally the culprits in poor performance.

If you post your query we can probably give some tips for improving performance. You should also post the underlying table structure including indexes.

If you want to begin analysis, use the Query Analyzer and execute "Display Estimated Execution Plan". You should see a graphical representation of the query plan. It will show query steps and estimated costs of the steps. You can pinpoint long running (high cost) steps. Look for table scans of long tables, costly merge operations, etc.

You can also use the "Index Tuning Wizard" to analyze if the table(s) have adequate index coverage for your query. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost