SQL Server Performance

Search Results

Search Again
  1. hbonvin

    Slow query with temporary table

    Post by: hbonvin, Sep 30, 2009 in forum: SQL Server 2005 Performance Tuning for DBAs
    The old server (slow server): Logical CPU : 2 Physical CPU : 1 Physical Memory (MB) : 3071 File Name Total Size in MB Available Space...
  2. hbonvin

    Slow query with temporary table

    Post by: hbonvin, Sep 29, 2009 in forum: SQL Server 2005 Performance Tuning for DBAs
    The update queries are the same based on the same data stored into the table ADCOSDT. When I display the execution plan, all access are on indexes,...
  3. hbonvin

    Slow query with temporary table

    Post by: hbonvin, Sep 28, 2009 in forum: SQL Server 2005 Performance Tuning for DBAs
    I don't clear the cache after the exections and the main tables have : ADCOSDT : 1024 rows (2x512) Adad : 281961 rows ADConta 281665 rows ADMaco...
  4. hbonvin

    Slow query with temporary table

    Thread by: hbonvin, Sep 28, 2009, 8 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    Hello, We have a something special with the logical reads on a update query. We prepare some records (512) into a physical temporary table. The...
Showing results 1 to 4 of 4
Search Again