Alex's Weblog

Weblog di Ermanno Goletto (Codename Alex - A Learning EXperience)
posts - 438, comments - 4214, trackbacks - 294

My Links

News

Il blog è stato
trasferito al
 seguente link:


DevAdmin Blog

Add my blog to Live

Foto

Curriculum Vitae


Il contenuto di questo blog e di ciascun post viene fornito “così come é”, senza garanzie, e non conferisce alcun diritto. Questo blog riporta il mio personale pensiero che non riflette necessariamente il pensiero del mio datore di lavoro.

Logo Creative Commons Deed


Logo MCTS

Logo MCSA

Logo MCP

Logo Microsoft Certified Business Management Solutions Professional

Microsoft Certified Business Management Solutions Specialist


Logo UGIdotNET UGIdotNET Contributor


Logo UGISS UGISS Contributor


Logo SysAdmin.it SysAdmin.it Staff


Article Categories

Archives

Post Categories

Blogs

Database

Development

Friends

IT

Knowledge Base

Links

MBS

MCP

MVP Sites

User Groups

Virtualization

Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

Con l'installazione base di WSS 3.0 (e di WSUS) viene installato il Windows Internal Database, per limitare la RAM utilizzata da questa instanza di SQL Server è possibile utilizzare SQLCmd.

Di seguito viene riportata la procedura per visualizzare e impostare la RAM utilizzata:

  1. Installazione del Microsoft SQL Server Native Client
  2. Installazione del Microsoft SQL Server 2005 Command Line Query Utility
  3. Aprire il prompt dei comandi.
  4. Connettersi all’istanza di SQL Server 2005 Embedded Edition Service digitando:
    “%ProgramFiles%\Microsoft SQL Server\90\Tools\binn\sqlcmd” -S \\.\pipe\mssql$microsoft##ssee\sql\query -E
  5. Visualizzare le impostazioni della RAM digitando:
    USE master
    GO
    EXEC sp_configure 'show advanced options', 1
    GO
    RECONFIGURE WITH OVERRIDE
    GO
    EXEC sp_configure 'max server memory (MB)'
    GO
    EXEC sp_configure 'show advanced options', 0
    GO
  6. Modificare le impostazioni della RAM digitando:
    USE master
    GO
    EXEC sp_configure 'show advanced options', 1
    GO
    RECONFIGURE WITH OVERRIDE
    GO
    EXEC sp_configure 'max server memory (MB)', MaxServerMemory
    RECONFIGURE WITH OVERRIDE
    GO
    EXEC sp_configure 'show advanced options', 0
    GO
  7. Disconnettersi all’istanza di SQL Server 2005 Embedded Edition Service digitando:
    EXIT

Problemi analoghi si possono avere con ISA 2004 o ISA 2006 e MSDE.

Per ulteriori informazioni si veda You may experience high memory usage on a computer that is running ISA Server 2004 or ISA Server 2006 and that logs messages to an MSDE database.

Print | posted on lunedì 9 giugno 2008 20:05 | Filed Under [ Links Tips IT SharePoint ]

Feedback

Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

This is often not desired, and causes a lot of noise in the management group, because these are not full blown instances of SQL, and some of our default monitoring does not work on them. Likely – these aren't critical SQL servers, and used for one-off applications that your SQL application team isn't even responsible for.
14/06/2010 11:22 | Agile Dinesh
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

Tremendous blog post, loads of beneficial information. I am about to show my buddies and ask them what they think.
SharePoint Consulting is a platform for the most admired companies to work together and pull resources.
05/02/2011 16:15 | jyonika
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

Nowadays, technology influence on our lives is ubiquitous. Even a normal clothes, such as LED T-Shirt high tech could make it stand out.
15/06/2011 14:35 | wikecamera
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

Save even more room on your actual desktop with this Mini Wireless Keyboard, buy it at a super low price from China's top online store tomtop.com.
21/06/2011 12:23 | Mini Wireless Keyboard
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

Great post it will help out the guys looking to get some gains in this filed. These tips are a helpful reminder. Thanks!Wireless Keyboard with Touchpad
28/06/2011 14:44 | Wireless Keyboard with Touchpad
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

Good post,........

Digital Pocket Scale
30/06/2011 12:53 | wikecamera
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

The discussion isn't very high on this topic yet in The Netherlands but it starts so your clear explaination is usefull.Green Laser Pointers
02/07/2011 08:42 | Green Laser Pointers
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

This is a really cool effect. Looks like it’s very tedious to do though. Thanks for sharing this.Puzzle Toys
22/07/2011 14:22 | wikecamera
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

It is so lucky to read your blog,it is full of useful message. Discover China's top Wireless Camera source online. Low price + worldwide fast free shipping.
28/07/2011 10:58 | Wireless Camera
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database


Create fan Bing bing image, although not so green and red, but you can dress the profile rock cock copy and smooth matt. Romona Keveza legends would you recommend the rehearsal dresses.a
12/06/2012 07:55 | wedding dress
Gravatar

# Discount DVD box sets

Marketing in packages is the most frequent way in promoting best DVD box sets films. It is typically divided by their class like horror, drama, comedy, action, and so forth.
07/11/2012 12:38 | Discount DVD box sets
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

Soft Magnetic Suppliers
Powder Flux core Suppliers
Pot-Core Suppliers
Amorphous Powder core Suppliers
Nanocrystalline Powder core Suppliers
Magnetic powder core Wholesalers
Powder core Wholesalers
Soft Magnetic Powder core Wholesalers
Alloy Powder core Wholesalers
Sendust core Wholesalers
Sendust Powder core Wholesalers
SUPER-MSS Wholesalers
Kool Mu Wholesalers
HTC200 Iron Powder core Wholesalers
Iron Powder core Wholesalers
TAF200 Wholesalers
High Flux core Wholesalers
20/02/2013 06:23 | power
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

spur gear manufacturer
Chinese spur gear manufacture
spur gear producers
Shaft Collar manufacturer
conveyor chain manufacturer
Chinese conveyor chain manufacture
conveyor chain producers
Brakes and clutch manufacturer

Adhesive tape
Bopp jumbo rolls
Bopp adhesive tape
Packing tape
Adhesive tape manufacture
Special adhesive tape
Printing adhesive tape
Stationary tape
Electrical insulating tape
Double sided tape
Foam tape
Masking tape
Warning tape
Laser tape
Color adhesive tape
Brown adhesive tape
PE stretch film
Carton sealing tape
26/06/2013 08:04 | power
Gravatar

# Check Cashing

I discovered your own content material upon Msn as well as I’ll certainly end up being back again quickly to locate more superb suggestions. Many thanks a great deal for all your data. Right now click here Check Cashing Many thanks with regard to good content material.
04/08/2017 18:43 | Pervez
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

Thanks a lot for sharing it, that’s truly has added a lot to our knowledge about this topic. Have a more successful day.

www.goassignmenthelp.com.au
19/09/2017 12:04 | Michael Doherty
Gravatar

# kamagra gold teeth nam

kamagra online
[url=http://lkkkopzql.com/]kamagra 100mg tablets india price[/url]
kamagra uk company
buy kamagra online
kamagra 100mg oral jelly review
24/04/2018 21:24 | MichaelDut
Gravatar

# kamagra 100mg tablets review nam

kamagra london reviews
[url=http://lkkkoqaql.com/]kamagra 100mg chewables[/url]
kamagra shop deutschland erfahrungen
kamagra jelly side effects
kamagra jelly amazon
25/04/2018 01:41 | Philipboago
Gravatar

# kamagra shop erfahrung nam

kamagra jelly 100mg usa
[url=http://lkkkspwql.com/]http://kamagrabst.com/[/url]
chewable kamagra polo 100mg
buy kamagra online
kamagra oral jelly for sale in usa
25/04/2018 03:53 | KennyLedge
Gravatar

# kamagra 100mg oral jelly price in egypt nam

kamagra oral jelly wirkungsdauer
[url=http://lkbkspwql.com/]buy kamagra 100 mg oral jelly[/url]
kamagra 100mg tabletta
kamagra 100mg side effects
kamagra oral jelly kaufen berlin
25/04/2018 12:47 | Jamespaure
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database


خدمات 86 - تحقیق و مقاله<br>

انجمن تخصصی وب هاستینگ<br>

سرویس وبلاگ دهی پد بلاگ<br>

سرویس وبلاگ دهی اسپورت بلاگ<br>

مدیریت محتوای نگار<br>

مکس وی پی اس<br>

نرم افزار IBSng<br>

میهن فایل<br>

دانلود طرهای توجیهی<br>

مارکت شاپ

downloadfilmirani5
Gravatar

# re: Windows SharePoint Services 3.0 - Limitare la RAM utilizzata dal Windows Internal Database

quicksodes
latest news in hindi
thesportsrumour

AVRiQ
Pestveda pest control services
surveillancekart security system
23/11/2018 11:29 | Ravi karan
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET