Search Results | SQL Server Performance Forums

Avoiding OS 1450 errors on SQL2KEE/Win2K3EE

Thread by: dbengineer, Jan 28, 2005, 1 replies, in forum: Performance Tuning for Hardware Configurations

Just a point of information for anyone running SQLServer 2000 Enterprise Edition on Windows Server 2003 Enterprise Edition, using extended memory...

Q834628 doesn't seem to work

Post by: dbengineer, Nov 24, 2004 in forum: Performance Tuning for Hardware Configurations

We are removing the /3GB option. Here are some articles we found. We also found that the available PTEs under normal conditions when /3GB is off was...

set working set size option

Thread by: dbengineer, Nov 24, 2004, 1 replies, in forum: Performance Tuning for Hardware Configurations

I am wondering if I should check the "Reserve physical memory for SQL Server" (set working set size) option in my sql server. Here is my...

Q834628 doesn't seem to work

Thread by: dbengineer, Nov 16, 2004, 5 replies, in forum: Performance Tuning for Hardware Configurations

I am running SQL Server 2000 Ent Edition, sp3a, W2K3, 8 CPU, 8GB (max sql memory 6GB), /3GB<br /><br />I applied hotfix Q834628, referenced here<br...

SQL Server Assertion: Issues

Post by: dbengineer, Nov 16, 2004 in forum: Performance Tuning for DBAs

What O/S are you using? What is your memory size on the box, and how many CPU? I've had assertion errors using W2K3, SQL 2000 EE sp3a, 8GB, 8CPU....

Table Error :: Possible chain linkage problem.

Post by: dbengineer, Nov 16, 2004 in forum: General DBA Questions

Every time I have had this error it has been due to bad sectors on disk. Doesn't matter what type of disk either, I've worked with many kinds. SQL...

Could not find database table ID 2, name 'tempdb'.

Thread by: dbengineer, Nov 16, 2004, 2 replies, in forum: General DBA Questions

On startup of my SQL Server 2000 Ent Edition service, I see the following logged: Error: 615, Severity: 21, State: 1 Could not find database table...

NAS device

Thread by: dbengineer, Oct 22, 2004, 3 replies, in forum: Performance Tuning for Hardware Configurations

Anyone out there running on a NAS device? If you have an opinion on running SQL 2K EE / W2K3 EE on a NAS, I'd be interested to hear it. We are...

Large memory advice

Post by: dbengineer, Oct 21, 2004 in forum: Performance Tuning for Hardware Configurations

I've been advised that I should remove my /3GB in boot.ini when I go to 16GB, because at that level the OS really has more trouble managing the AWE...

Large memory advice

Thread by: dbengineer, Oct 20, 2004, 4 replies, in forum: Performance Tuning for Hardware Configurations

Hi all, We are currently running Win 2003 Server Enterprise Edition / SQL Server Enterprise Edition 2000, 8GB memory. I want to go to 16GB memory,...