This is a discussion on Query Memory? within the SQL Server forums, part of the Microsoft SQL Server category; --> I had posted a msg in another thread asking about forcing MSSQL to use query memory vs disk I/O ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I had posted a msg in another thread asking about forcing MSSQL to use query memory vs disk I/O due to long fields. Is there any way for me to benchmark what SQL is using in Memory vs. allocated memory. We are running SQL 2000 Standard, not Enterprise, so it can only address the 2GB. |
| ||||
| |
| Thread Tools | |
| Display Modes | |
|
|