insufficent Memory Problem 1 - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

insufficent Memory Problem 1

Author

Topic

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-04-18 : 06:50:52

1.WARNING: Failed to reserve contiguous memory of Size= 1048576

Yogesh V. Desai. | SQLDBA|

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-18 : 06:54:29

Duplicate Post: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82268[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-18 : 07:01:38

Is this how you get your post count up?

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-04-18 : 07:06:03

quote:
Originally posted by Peso

Is this how you get your post count up?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82268
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82271
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82272
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82273
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82274
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82275
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82276
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82277
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82278

Peter Larsson
Helsingborg, Sweden

If you have solution please help don't count my post,I am explaing the different log errors..or don't pass just comments.I am in critical condition. You guys better understand

Yogesh V. Desai. | SQLDBA|

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-18 : 07:10:30

quote:
Originally posted by YogeshDesai

quote:
Originally posted by Peso

Is this how you get your post count up?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82268
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82271
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82272
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82273
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82274
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82275
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82276
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82277
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82278

Peter Larsson
Helsingborg, Sweden

If you have solution please help don't count my post,I am explaing the different log errors..or don't pass just comments.I am in critical condition. You guys better understand

Yogesh V. Desai. | SQLDBA|

It's you who should better understand the forum behavior and manners. Do you think creating topic for each of the error you get is going to get you any help? Most probably you will just end up getting banned for not following the decorum.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-04-18 : 07:12:37

quote:
Originally posted by harsh_athalye

quote:
Originally posted by YogeshDesai

quote:
Originally posted by Peso

Is this how you get your post count up?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82268
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82271
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82272
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82273
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82274
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82275
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82276
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82277
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82278

Peter Larsson
Helsingborg, Sweden

If you have solution please help don't count my post,I am explaing the different log errors..or don't pass just comments.I am in critical condition. You guys better understand

Yogesh V. Desai. | SQLDBA|

It's you who should better understand the forum behavior and manners. Do you think creating topic for each of the error you get is going to get you any help? Most probably you will just end up getting banned for not following the decorum.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

next time I will take care for that thank you for your valuable time

Yogesh V. Desai. | SQLDBA|

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-18 : 07:17:12

Searching Microsoft site with this text "Failed to reserve contiguous memory of Size" took me 20 seconds to find these two articles

http://support.microsoft.com/kb/832674
http://support.microsoft.com/kb/903002

Do they help you?

Peter Larsson
Helsingborg, Sweden

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-18 : 07:19:01

Edit your connection string to include this
Packet Size=4096

Also make sure you are up to date with service packs for SQL Server.
Currently SP2 for SQL Server 2005 and SP4 for SQL Server 2000.

Peter Larsson
Helsingborg, Sweden

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-18 : 08:15:23

Any progress yet?

Peter Larsson
Helsingborg, Sweden

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2007-04-18 : 09:14:20

Is this SQL Server serving as the back end for a Sharepoint Teams installation?

X002548
Not Just a Number

15586 Posts

Posted - 2007-04-18 : 09:16:44

Bill,

If there isn't any more clear example of having more mod's, this is it!

Good Lord

What happened to Damian and Rob btw?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-04-18 : 10:57:16

Hi guys, thanks for all the suggestion I have checked the links.mostly they asking to install latest service pack but I have already installed required service pack SP4 and hotfix build 2140

I search on microsoft site they have suggested to apply hotfix build 2187. Let 's see I have to take down-time for this.

Thank you very much for all your efforts

Yogesh V. Desai. | SQLDBA|

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-04-18 : 10:59:14

very soon i will give you the update son this issue

Yogesh V. Desai. | SQLDBA|

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-04-24 : 03:47:57

Hi All I have installed hotfix post-SP4 build 2187.Now database is under observation.Let's c. I havn't received any error related to Memory Problem

Yogesh V. Desai. | SQLDBA|

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-24 : 04:00:06

Great.

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources