RE: SBS2003 Standard - managing the SQL installation?
- From: v-chayan@xxxxxxxxxxxxxxxxxxxx ("Charles Yang [MSFT]")
- Date: Tue, 25 Oct 2005 07:35:32 GMT
HI,
Thanks for updates. I am glad to hear that you have found it. Here is more
information for how to use SQL command line for MSDE 2000:
325003 How To Manage the SQL Server Desktop Engine (MSDE 2000) by Using the
http://support.microsoft.com/?id=325003
Hope the above information helpful; please feel free to let me know the
results. I am glad to be of further assistance.
Best regards,
Charles Yang (MSFT)
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: Leythos <void@xxxxxxxxxxx>
| Newsgroups: microsoft.public.windows.server.sbs
| Subject: RE: SBS2003 Standard - managing the SQL installation?
| References: <Yde7f.156753$lI5.123100@xxxxxxxxxxxxxxxxxxxxxx>
<7ra0K3Q2FHA.3936@xxxxxxxxxxxxxxxxxxxxx>
<Uah7f.70504$Hs.52774@xxxxxxxxxxxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-15"
| Content-Transfer-Encoding: 7bit
| User-Agent: MicroPlanet-Gravity/2.70.2067
| X-Face:
A;M@wltH;y<_[X{sb87LCnwW0{GYN;Z<\@Q/T}aTqdjfj^J%XV3Om]F7_"(d:ajl~|a:@EF
| li/1j='OK"&W$2Z!)tCRWs}v2R*kIU,f~![aAN:!d(U"!VP7D74t`]z^ZlgC@b
| X-No-archive: yes
| Lines: 40
| Message-ID: <Pmh7f.70507$Hs.65363@xxxxxxxxxxxxxxxxxxxxxx>
| Date: Tue, 25 Oct 2005 03:10:39 GMT
| NNTP-Posting-Host: 24.123.138.210
| X-Complaints-To: abuse@xxxxxx
| X-Trace: tornado.ohiordc.rr.com 1130209839 24.123.138.210 (Mon, 24 Oct
2005 23:10:39 EDT)
| NNTP-Posting-Date: Mon, 24 Oct 2005 23:10:39 EDT
| Organization: Road Runner High Speed Online http://www.rr.com
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!g
nilink.net!cyclone.rdc-nyc.rr.com!news-wrt-01.rdc-nyc.rr.com!news-wrt-01.ohi
ordc.rr.com!news-server.columbus.rr.com!tornado.ohiordc.rr.com.POSTED!53ab27
50!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:164219
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| In article <Uah7f.70504$Hs.52774@xxxxxxxxxxxxxxxxxxxxxx>,
| void@xxxxxxxxxxx says...
| > In article <7ra0K3Q2FHA.3936@xxxxxxxxxxxxxxxxxxxxx>, v-
| > chayan@xxxxxxxxxxxxxxxxxxxx says...
| > > HI Leythos,
| > >
| > > Welcome to SBS newsgroup.
| > >
| > > Issue descriptions:
| > > ==============
| > >
| > > I understand that you want to set the limitation of SQL MSDE for
sharepoint
| > > services to use only 512MB RAM.
| > >
| > > Analyzing and suggestions:
| > > ===============
| > >
| > > Generally speaking, we can set the limitations of memory for any MSDE
| > > instance. You can use command line to complete this goal:
| > >
| > > Run
| > > osql -E -S your sbs server name\sharepoint
| > >
| > > Then you will be allowed to enter SQL command line:
| > >
| > > Use the following commands to set the value:
| > >
| > > EXEC sp_configure ''min server memory'', 0
| > > EXEC sp_configure ''max server memory'', 02147483647
| >
| > Is the "02147483647" the value for 512MB of RAM?
|
| Sorry to answer my own post, I found the BOL and set the MAX to 512 and
| the MIN to 512 then did a RECONFIGURE WITH OVERRIDE
|
|
| --
|
| spam999free@xxxxxxxxxx
| remove 999 in order to email me
|
.
- References:
- RE: SBS2003 Standard - managing the SQL installation?
- From: "Charles Yang [MSFT]"
- RE: SBS2003 Standard - managing the SQL installation?
- Prev by Date: Company Web
- Next by Date: Re: OT- Veritas Backup
- Previous by thread: RE: SBS2003 Standard - managing the SQL installation?
- Next by thread: RE: Unable to ping client2
- Index(es):
Relevant Pages
|
