September 23, 2013 at 5:33 am
what are the symptoms of Memory Problems in sql server
September 23, 2013 at 5:57 am
Queries would run slowly.
September 23, 2013 at 6:38 am
Memory pressure won't necessarily cause slow queries.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2013 at 11:44 pm
Chapter 4, Page #149
If SQL Server is forced to operate with an insufficient amount of memory, it will be able
to store fewer data pages in the buffer pool. As a result, higher physical I/O is needed to
bring data pages from disk into the buffer pool as they are requested, and performance
will degrade.
September 24, 2013 at 4:06 am
I said it won't necessarily cause slow queries, not that it won't ever cause slow queries, and you really don't need to quote from a book I helped write.
Slow queries can be caused by many things, not just memory pressure, so you can't use that to tell if there's memory pressure as the memory could be fine and there could be another cause (lack of indexes for example).
I have seen a case where the server was under memory pressure, memory was added and performance degraded severely.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply