SQL Low performance

Hot Topic

Data Source for Process Cube
How Can I Change the data type of the parameter for the Deployed Stored Procedure ??
Implementing co-related queries with EXISTS in MDX
SQL Express vs Clarion
Getting up and running with Visual SQL Server 2005 Express and Visual Web Developer 2005 Express
ETL using SSIS
IsQueryStoredProcedure property won't stay set
Sync'ing a merge subscription before removal.
Auto Process Messages in Target Queue
Remove rtf code from text

SQL Server

Saving a query to a csv file
Remove the lines from the query output
Cannot find publication wizard
Miscellaneous option???
error when changing published article at the subscriber
Mdx expression to get the parameter value
VS 2005 Report Preview Toolbar different from RS 2005 report Manager preview
Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?
How to close all open "handles" to a SQL Server 2005 express DB?
table schema changes not being propagated - merge replication

SQL Low performance

Dears,

I am connection to SQL SERVER 2005 using an ODBC connection through ASP. I have a database with about 2 million records. When I run a huge query from a client all other clients can not work during mentioned huge query return results. Sometimes the time will goes far an all other connections will drop due to Time Out problem.

Any suggestion



Answer this question

SQL Low performance

  • quix ltd

    Check indexes first. If you do a serach in a data or join tables and do not have proper indexes on a joined/searched fields, it will work very slow. Also check if your query locks records. If it does, it is also possible that other users will not be able to get results until you finish to work with this query. Another suggestion is to minimize selection, especially i a Web environment. There is no reason to make huge selections

  • Rup

    Moving to the "SQL Server Database Engine" Forum.



  • SQL Low performance
Answer this question