Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
RonKinney
Starting Member
2 Posts |
Posted - 2010-02-23 : 12:03:03
|
SQL Server 2005 Ent x64Memory 24574MBQuery Wait -1There was a canned application that could obtain only 400MB of RAM. What could possibly have caused this? My thought is that the query took a long time to run. Any other ideas would be greatly appreciated.Thanks,Ron |
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2010-02-25 : 12:55:40
|
How many processdors on this box?May be you need to check the Query, before you run ... -- Stats updated or not -- Proper index available or notWith RegardsSR |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-25 : 14:32:43
|
SQL Server is going to use all the RAM u allow it. This will starve any other applications for memory.Should have a dedicated server for your sql server if at all possibleCan set MAX Server memory in SSMS if you need to leave memory for other apps. Should do this anyway to leave at least 2 GB for OS |
|
|
|
|
|