none
sql server performance low RRS feed

  • General discussion

  • I am working on different database at same time while working on these database the sql server performance goes very low.

    Thursday, November 12, 2009 6:46 AM

All replies

  • What is the physical memory on your box ? Do you see some blocks in your query ?
    Can you be more specific ..


    Thanks, Leks
    Thursday, November 12, 2009 6:56 AM
    Answerer
  • hi,

    The total physical memory 3 GB and sql server.exe usage 1.7 GB

    I am working on payroll project in that application i required processing 1000 employees at a same time for multiple companies for each companies have separate database.

    My processing logic:

    first select all employees and each employee generate dynamic query and fired through front end not return through SP
    (due to dynamically generation of columns in each tables.)

    One employee refers 12 tables max
    each table contains more than 10000 records in first month processing after each month it will increase by same (10000 records in tables) and process on it.

    Thursday, November 12, 2009 7:12 AM
  • Try to run a SQL profiler trace and see what is causing the slowness in your queries .
    Thanks, Leks
    Thursday, November 12, 2009 8:00 AM
    Answerer