SQL Server Performance

Search Results

Search Again
  1. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Jan 6, 2003 in forum: Performance Tuning for DBAs
    I tried the index tuning wizard. Thanks for all your efforts.
  2. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Jan 2, 2003 in forum: Performance Tuning for DBAs
    Just wondering how things were coming. I haven't heard anything yet. Happy New Year!
  3. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Dec 20, 2002 in forum: Performance Tuning for DBAs
    I emailed the file - did you get a chance to look at it?
  4. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Dec 19, 2002 in forum: Performance Tuning for DBAs
    ok, i've got the trace. how do i get it to you guys.
  5. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Dec 18, 2002 in forum: Performance Tuning for DBAs
    ok, let me see what I can get for you - thanks again...
  6. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Dec 18, 2002 in forum: Performance Tuning for DBAs
    Whoops, I was gonna reply to the question about id'ing the query, etc. and left a quote by mistake. I'm an old mainframer. I've done some Unix and...
  7. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Dec 17, 2002 in forum: Performance Tuning for DBAs
    I did, but maybe I didn't run it long enough or trace the right things because it didn't show any problems.
  8. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Dec 17, 2002 in forum: Performance Tuning for DBAs
    SQL Server standard edition Microsoft Windows NT 5.0 SQL 8.00.534(SP2) NT Intel X86 OS memory 2175(MB) 2 Processors 2,227,688(KB) RAM
  9. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Dec 17, 2002 in forum: Performance Tuning for DBAs
    Under parallelism, I changed to Use 1 processor. It didn't help the transaction. The "minimum query plan" is still set to 5. Should that be changed...
  10. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Dec 17, 2002 in forum: Performance Tuning for DBAs
    found it! do i need to restart the server?
  11. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Dec 17, 2002 in forum: Performance Tuning for DBAs
    I tried the rebuild and it helped a tiny bit. Where do I check for the degree of parallel?
  12. ncblues

    SQL 7 v.s. SQL 2000

    Post by: ncblues, Dec 16, 2002 in forum: Performance Tuning for DBAs
    thanks, I'll try that
  13. ncblues

    SQL 7 v.s. SQL 2000

    Thread by: ncblues, Dec 16, 2002, 32 replies, in forum: Performance Tuning for DBAs
    We have an application that takes 4 times longer to run in the production SQL 2000 environment than it did in the development SQL 7 environment....
Showing results 1 to 13 of 13
Search Again