Performance Question

Hot Topic

Monitoring a folder for a file - start ssis
Bug?
Where is Auto Save in SQL Management Studio???
Full-text Index Question
File Groups
Cannot see server name in the pick list
Getting the place number for a specifik ID, from a select list
start from expression
Web Sync: strange behaviour with the snapshot size
Data Flow: Converting data in multiple columns

SQL Server

Upgrade Sql Express SP1 to SQL Server 2005 Standard
Resolving an attribute member from a member property
SQL Query Analyzer: Open a new query window with script
Can I add a foriegn key on a indexed view to reference other table
Changing flat file connection file name property
inserting data for testing
Proclarity and SQL Server 2005
AMO Security Scripting Problem
the error of the SMTP in Sql Server 2005 notification services
missing tables

Performance Question

Hi, I have a sql2000 server running and I have a asp.net app that accesses this server. At the moment I am using 2 different databases to get information from and such, one database I have a bit of control over the other I am not allowed to touch without special permissions due to the sesitivity of the data. The issue is that my app is not going very fast when it comes to database calls.

I need to index some tables but I am unsure what actually happens to the data when I do this, I have one table that has ~600,000 rows and that is alot to sort through as you can imagine. This table is on the sensitive database, so I am hesitant to touch it, but I really need a performance boost somehow, can anyone suggest something to help me solve my performance problem

I have posted around on the asp.net forums but the help is limited and most people say 99% of the time its the database calls that are the problem.


Thanks for the time,
Mark

Answer this question

Performance Question

  • Michael_Shao

    Ok thats good advice thanks. When you say that I should evaluate the query plans, is that using the feature in the management studio that shows the execution plan of a given query If so what should I be looking for I dont really understand the details I am being shown

    Thanks Jens

  • tarponboy11

    Thanks for the reply Jens, I am quite new to Indexes in SQL Server 2000, I suppose it is always best to use them no matter what database you have, but is there any risk to the data by putting them on I just dont want to corrupt anything. And as far as I can tell, there are no indexes on any tables in the database that I am allowed to touch.

    I should mention too, that I am using views to look onto the sensitive database, will this affect permormance

    thanks
    Mark

  • Dave Gurr

    Many sites already discussed about this topic, it would be too much describing the different symbols in here, but have a look on www.sqlserverperformance.com this iste can be a good starting point for finding out ways to tweak the performance of the database.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • c_shah

    Its hard to just suggest anything without knowing your physical and logical design, but if you have many sort operations, try to put indexes on the sorted columns. If you are joining a lot of data, do also put an index on the joined columns. 600.000 is not that much data, perhaps you might also have an issue on your physical design

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • Smartcard User

    Actually there is no risks using indexes. If you use them on a separate physical storage location you can also put the load of the indexes from the database (but you don’t have to) The best way would be to evaluate the uqery plans of your queries fired against the database. They should tell you if data is retrieved by using cost extensive scans etc.

    HTH, Jens Susmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • Performance Question
Answer this question