SQL Server Tips

Getting Started with Web applications development with servlets and JSP - Part 5: Filters

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.


	Just Learned

Upload Image

Close it

Select File

Learned something today? Share it, or learn from what others have learned today


	Like

Invite Friends

Tips · Submit A Tip · Members (427) · Preferences · Feedback · Most Liked · Most Learned · Most Discussed · Silver Rated

SQL Server - Replication error "There is insufficient system memory to run this query" - Log reader agent error for subscriber d

Oct 31 2011 10:47AM by Paresh Prajapati

Replication was stopped for one subscriber database due to memory issue with following error,

Error messages:
There is insufficient system memory to run this query. (Source: MSSQL_REPL, Error number: MSSQL_REPL27453)

It got resolved with following commands in that subscriber database server which flush the distributed query connection cache and all unused cache entries from all cache.

DBCC FREESESSIONCACHE
DBCC FREEPROCCACHE
DBCC FREESYSTEMCACHE('ALL')

Did you encountered such memory issue? and how did you resolved?

3 Comments

I knew it but its intersting to put it in Replication perspective

Thanks

commented on Oct 31 2011 10:52AM .

Nitin

428 · 0% · 55

Just curious to know whether you've read the following which indicates that there may be performance trade-offs when using a MSTVF. Bit difficult to compare as you haven't provided any code :-)

MSTVF Performance

commented on Nov 1 2011 5:48AM .

Jeff Wharton

53 · 4% · 930

The important question would be - why did your server run out of memory? I have seen production systems (using replication) run for as long as 6 months without the need of an outage as small as 10minutes.

Anyway, running the 3 DBCC statements mentioned would probably create more problems in terms of...guess what? performance!

@Jeff: Great link! Thank-you! I knew about the issues with MSTVFs, but did not know why they were not as good as ITVFs.

commented on Nov 1 2011 12:07PM .

Nakul Vachhrajani

6 · 26% · 5926

Your Comment

Sign Up or Login to post a comment.

"SQL Server - Replication error "There is insufficient system memory to run this query" - Log reader agent error for subscriber d" rated 5 out of 5 by 6 readers +Paresh Prajapati