Running 2 x Windows 2003 x64 Enterprise in a failover cluster. 24gb RAM each<BR>SQL 2005 x64 SP2<BR><BR>My SQL instance is running at about 17gb of pagefile usage. Instance memory ceiling is set at ...
Perhaps a bit of an esoteric problem but... I have a SQL Server 2008 instance on EC2 (running on 2008 R2) under heavy load. I'm trying to optimize I/O performance and after a couple iterations I'm ...
I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...