Search Results | SQL Server Performance Forums

Query response is very slow after SQL Server 2000 SP 4 upgrade

Thread by: hftho, Sep 6, 2007, 2 replies, in forum: General DBA Questions

Hi, dear all, I encounter performance issue after I upgrade my SQL Server 2000 from SP3A to SP4. Those query that responsed very fast earlier, now...

Transaction Log

Thread by: hftho, Oct 13, 2006, 6 replies, in forum: General DBA Questions

Hi, my database is configured to be in simple recovery mode, but the log file still grows up to 920MB. I thought with simple recovery mode,...

Transactional Replication

Thread by: hftho, Oct 3, 2006, 2 replies, in forum: Performance Tuning for SQL Server Replication

In my scenario, I've a production server and I'm thinking to setup a backup server and restore a copy of my production database to the backup server,...

Memory requirement

Thread by: hftho, Oct 2, 2006, 2 replies, in forum: General DBA Questions

Dear all, I have a table with size of 2GB++ and as I'm using the SQL Server Standard edition, so the maximum addressible memory is only 2GB even...

Average Disk Queue Length

Thread by: hftho, Sep 24, 2006, 7 replies, in forum: General DBA Questions

The system becomes very slow while the Average Disk Queue Length in the db server (SQL server 2000 standard edition) is maintaining at 100%. This...

Maximum addressible memory of SQL Server 2000

Thread by: hftho, Sep 14, 2006, 4 replies, in forum: General DBA Questions

Hi, dear all, We've SQL Server 2000 Standard Edition running on Window 2003 Standard Edition server on a XEON machine that has 8GB of physical...

Fixed the database size & disable auto Shrink

Thread by: hftho, Sep 11, 2006, 2 replies, in forum: General DBA Questions

Hi, I would like to know if I can change the database file allocated size by simply entering a new value in the Space allocated at the Data File...