How to Set Max Memory?

I don't have much (if any) experiance running an SQL server. I
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:

>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:

> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>
>|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
>
>
>
>
>
>
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.

How to Set Max Memory?

I don't have much (if any) experiance running an SQL server. I
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!
You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:

>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!
|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:

> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>
>
|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
>
>
>
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.

How to Set Max Memory?

I don't have much (if any) experiance running an SQL server. I
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
> >I don't have much (if any) experiance running an SQL server. I
> >currently have Windows SBS2k installed with 2gb of memory for the
> >system. I would like to install more, but my budget doesn't allow for
> >it at the moment.
> >
> >I know there is a way to set the max memory an SQL instance can use,
> >but I can't find a real step by step instruction.
> >
> >The server is running SBS 2k3 standard, so its only the SQL desktop
> >edition.
> >
> >First thing I need to know is how I know what instance is associated
> >w/ what PID.
> >
> >Next, I need some hand holding on what I need to do to set the max
> >memory.
> >
> >
> >Any help would be appreciated.
> >Thanks!
>|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
> >I don't have much (if any) experiance running an SQL server. I
> >currently have Windows SBS2k installed with 2gb of memory for the
> >system. I would like to install more, but my budget doesn't allow for
> >it at the moment.
> >I know there is a way to set the max memory an SQL instance can use,
> >but I can't find a real step by step instruction.
> >The server is running SBS 2k3 standard, so its only the SQL desktop
> >edition.
> >First thing I need to know is how I know what instance is associated
> >w/ what PID.
> >Next, I need some hand holding on what I need to do to set the max
> >memory.
> >Any help would be appreciated.
> >Thanks!- Hide quoted text -
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.

How to set max connections?

I'm use class.forName to load SQLServerDriver. If I want to set the max
connections to other than the default, how do I do that?
Thanks,
-- Frank
Frank wrote:

> I'm use class.forName to load SQLServerDriver. If I want to set the max
> connections to other than the default, how do I do that?
> Thanks,
> -- Frank
What is 'max connections'? It is not a driver property that I know of...
Joe Weinstein at BEA
|||Hello Frank,
I think you are talking about the server-side setting called "user
connections". There is no client-side property that you can set to do the
same.
You can configure this value from Enterprize Manager on the Connections tab
or with a
sp_configure 'user connections' statement in Query Analyzer. Please see the
"user connections Option" Books Online topic for more important information
about this setting.
Thanks,
Kamil
Kamil Sykora
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/securXity.
| Thread-Topic: How to set max connections?
| thread-index: AcWMfQTydRvRJc6qT2ieYQQnWcyC1g==
| X-WBNR-Posting-Host: 204.64.62.132
| From: "=?Utf-8?B?RnJhbms=?=" <Frank@.discussions.microsoft.com>
| Subject: How to set max connections?
| Date: Tue, 19 Jul 2005 09:15:03 -0700
| Lines: 5
| Message-ID: <39B925FA-078E-4F4C-AD28-3DA12EF8E20C@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.jdbcdriver:1201
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| I'm use class.forName to load SQLServerDriver. If I want to set the max
| connections to other than the default, how do I do that?
|
| Thanks,
| -- Frank
|