Twan, I saw your note about AWE adding overhead. How would one determine if that were the case? Would you use something in PERFMON to trap this?...
Satya, this page cannot be found. Could you report? Terry Crosby
We want to establish a warm standby for our production database (SQL 2K sp3, approx. 170GB in size). Which would be the better method to accomplish...
Actually, we did set max memory to 4.8, figuring 1GB for the OS was sufficient. SQL is the only thing running on this server and yes, it's the...
We use Spotlight for SQL server and I can verify that SQL is using 4.8 GB. What other AWE setting are there? All we did was enable AWE, grant...
Another thing to try, if the log doesn't matter to you, issue dump tran DBNAME with truncate_only from query analyzer, then issue the DBCC...
We just put in a new server with 6GB of RAM. I set SQL 2Ksp3 max memory value at 4 GB, put in /3GB/PAE in my boot.ini, enabled AWE and granted...
While this is turned on for several of my databases, it doesn't seem to do anything. Am I missing something? To get my databases to shrink, it seems...
Separate names with a comma.
