April 4, 2002 at 4:42 am
I have a server running SQL 7 Server and it
has hundreds of clients using merge replication via Internet. The database contains about 100 tables and about million
rows, total. Now at the customer end replication has started to give "out of memory"-message all the time. What could be the reason, it does not seem to be related on the memory amount on the customer's computer. The software is programmed with Visual Basic 6, and database is MS SQL Server
7.0 with SP3 installed. Any hints?
Thanks!
Tapio Koivisto
April 4, 2002 at 5:07 am
Since you are not talking about a time consuming process, a posibillity is:
Not all the clients are using the same version of SQL Server Objects...
Check (question), are all your clients using the same SP3?
April 4, 2002 at 5:13 am
Check this out
Bug ID:54978
Link:Q225501
FIX: SQL-DMO Operations on SQL Server 7.0 Uses More Memory
at: http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q225501
April 4, 2002 at 5:27 am
Could be an MDAC issue, VB SP issue. Check the event viewer and it may have more details. Also may want to get a snapshot of the memory and running apps when this happens to see if anything specific is eating resources that may be the culprit.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply