master sysmessages: according

Showing posts with label according. Show all posts

Friday, March 30, 2012

Max mirroring DB on a 64-bit sysstem?

According to BOL we know

"On a 32-bit system, database mirroring can support a maximum of about 10 databases per server instance because of the numbers of worker threads that are consumed by each database mirroring session."

My question is: What is maximum number of mirrored DB we can deploy on 64-bit system per one sql instance?

It depends. Do you have a 64-CPU box with 1 TB of RAM or a 4 CPU box with 4 GB? The variety of 64-bit hardware available makes specific guidance difficult.

You will need to test your configuration appropriately regardless.

|||

Peter thanks for you answer.

We have got the next configuration :

HP Superdome (1 cell) 4 CPU?(Dual core Itanium 2 1.6GHz, 24 MB Cache),?32GB.

|||

In the case of multiple databases, I use a different tack to overcome the problem. If I find any database failed over, I run SQL commands to fail them all over. "ALTER DATABASE [dbname] SET PARTNER FAILOVER" you must proceed the command with "USE [master]". It works in my case as i am running web code against multiple databases at any given point in time, so I have to have them all failover at the same time anyways. The statement to return the state of each database is "SELECT * from sys.database_mirroring WHERE mirroring_guid IS NOT NULL" I read the values programatically and run the appropriate failover statements depending on the values returned.

|||This was extremely useful, I copied it verbatim into a scheduled task that runs every minute and checks this, because we've had the same issue where only some but not all databases fail over. There should be an SQL Server feature to make multiple databases "atomic" for the purpose of failover.sql

Max mirroring DB on a 64-bit sysstem?

According to BOL we know

"On a 32-bit system, database mirroring can support a maximum of about 10 databases per server instance because of the numbers of worker threads that are consumed by each database mirroring session."

My question is: What is maximum number of mirrored DB we can deploy on 64-bit system per one sql instance?

It depends. Do you have a 64-CPU box with 1 TB of RAM or a 4 CPU box with 4 GB? The variety of 64-bit hardware available makes specific guidance difficult.

You will need to test your configuration appropriately regardless.

|||

Peter thanks for you answer.

We have got the next configuration :

HP Superdome (1 cell) 4 CPU?(Dual core Itanium 2 1.6GHz, 24 MB Cache),?32GB.

|||

Max mirroring DB on a 64-bit sysstem?

According to BOL we know

"On a 32-bit system, database mirroring can support a maximum of about 10 databases per server instance because of the numbers of worker threads that are consumed by each database mirroring session."

My question is: What is maximum number of mirrored DB we can deploy on 64-bit system per one sql instance?

It depends. Do you have a 64-CPU box with 1 TB of RAM or a 4 CPU box with 4 GB? The variety of 64-bit hardware available makes specific guidance difficult.

You will need to test your configuration appropriately regardless.

|||

Peter thanks for you answer.

We have got the next configuration :

HP Superdome (1 cell) 4 CPU?(Dual core Itanium 2 1.6GHz, 24 MB Cache),?32GB.

|||

Max memory for SQL 2000 standard edition

Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
Please, can you tell me which is really true. I need to buy right edition of
sql server...
thanksHi
SQL Server Standard Edition has a 2GB memory limitation.
Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB is
not supported)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Roman Snajdr" wrote:
> Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
> Please, can you tell me which is really true. I need to buy right edition of
> sql server...
> thanks
>
>|||Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server Standard Edition has a 2GB memory limitation.
> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB is
> not supported)
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Roman Snajdr" wrote:
> > Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
> > Please, can you tell me which is really true. I need to buy right edition of
> > sql server...
> > thanks
> >
> >
> >|||No
2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the patch
level.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kathy" <Kathy@.discussions.microsoft.com> wrote in message
news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...
> Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
> "Mike Epprecht (SQL MVP)" wrote:
>> Hi
>> SQL Server Standard Edition has a 2GB memory limitation.
>> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB
>> is
>> not supported)
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Roman Snajdr" wrote:
>> > Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4
>> > GB.
>> > Please, can you tell me which is really true. I need to buy right
>> > edition of
>> > sql server...
>> > thanks
>> >
>> >
>> >|||In another dialog, you said something about switch /3gb in boot.ini. How does
that works? Also in the same thread of the discussion, another person said
2GB can be used even though the switch is set up. Are there officail
documents available on this issue from MSFT? Thanks.
"Mike Epprecht (SQL MVP)" wrote:
> No
> 2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the patch
> level.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...
> > Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> Hi
> >>
> >> SQL Server Standard Edition has a 2GB memory limitation.
> >> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB
> >> is
> >> not supported)
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >>
> >>
> >> "Roman Snajdr" wrote:
> >>
> >> > Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4
> >> > GB.
> >> > Please, can you tell me which is really true. I need to buy right
> >> > edition of
> >> > sql server...
> >> > thanks
> >> >
> >> >
> >> >
>
>|||Hi Kathy
This is the official word from Microsoft:
How to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Kathy" <Kathy@.discussions.microsoft.com> wrote in message
news:93BFF759-501C-4126-A75D-971E2C676A30@.microsoft.com...
> In another dialog, you said something about switch /3gb in boot.ini. How
> does
> that works? Also in the same thread of the discussion, another person said
> 2GB can be used even though the switch is set up. Are there officail
> documents available on this issue from MSFT? Thanks.
> "Mike Epprecht (SQL MVP)" wrote:
>> No
>> 2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the
>> patch
>> level.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
>> news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...
>> > Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
>> >
>> > "Mike Epprecht (SQL MVP)" wrote:
>> >
>> >> Hi
>> >>
>> >> SQL Server Standard Edition has a 2GB memory limitation.
>> >> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but
>> >> /3GB
>> >> is
>> >> not supported)
>> >>
>> >> Regards
>> >> --
>> >> Mike Epprecht, Microsoft SQL Server MVP
>> >> Zurich, Switzerland
>> >>
>> >> MVP Program: http://www.microsoft.com/mvp
>> >>
>> >> Blog: http://www.msmvps.com/epprecht/
>> >>
>> >>
>> >>
>> >> "Roman Snajdr" wrote:
>> >>
>> >> > Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4
>> >> > GB.
>> >> > Please, can you tell me which is really true. I need to buy right
>> >> > edition of
>> >> > sql server...
>> >> > thanks
>> >> >
>> >> >
>> >> >
>>
>|||Thanks Kalen. That helps a lot.
"Kalen Delaney" wrote:
> Hi Kathy
> This is the official word from Microsoft:
> How to configure memory for more than 2 GB in SQL Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> news:93BFF759-501C-4126-A75D-971E2C676A30@.microsoft.com...
> > In another dialog, you said something about switch /3gb in boot.ini. How
> > does
> > that works? Also in the same thread of the discussion, another person said
> > 2GB can be used even though the switch is set up. Are there officail
> > documents available on this issue from MSFT? Thanks.
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> No
> >>
> >> 2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the
> >> patch
> >> level.
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> IM: mike@.epprecht.net
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> >> news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...
> >> > Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
> >> >
> >> > "Mike Epprecht (SQL MVP)" wrote:
> >> >
> >> >> Hi
> >> >>
> >> >> SQL Server Standard Edition has a 2GB memory limitation.
> >> >> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but
> >> >> /3GB
> >> >> is
> >> >> not supported)
> >> >>
> >> >> Regards
> >> >> --
> >> >> Mike Epprecht, Microsoft SQL Server MVP
> >> >> Zurich, Switzerland
> >> >>
> >> >> MVP Program: http://www.microsoft.com/mvp
> >> >>
> >> >> Blog: http://www.msmvps.com/epprecht/
> >> >>
> >> >>
> >> >>
> >> >> "Roman Snajdr" wrote:
> >> >>
> >> >> > Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4
> >> >> > GB.
> >> >> > Please, can you tell me which is really true. I need to buy right
> >> >> > edition of
> >> >> > sql server...
> >> >> > thanks
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >>
> >
>
>

Monday, March 26, 2012

max connections

hello everybody,
does anyone knows the max connections the sql server can work with. i need to know about the sql server capability according to hardware limits ( for exe:how many connection can the sql manege on 2 cpu's computer with 2.gb ram, etc')
thanks
Ruby
Hi
The number of connections would be limited by what you are licenced for. If
you are looking for a figure for the number of connections per second this
will mainly be limited by the capabilities of your network, although if you
expect this to be high you should probably be looking at connection pooling.
You should also look at the work carried out by each person as this will
effect the time they are connected and your hardware maybe incapable of
sustaining a reasonable level of service to the users.
For maximum capacity settings see:
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
Your hardware vendor may be able to give you some idea of what you can
expect and your should specify your requirements as part of the tender
process. This should also allow you to benchmark your application on their
hardware as part of the acceptance process.
John
"ruby" <anonymous@.discussions.microsoft.com> wrote in message
news:9245A3AA-C494-413A-A4B8-6B58C71DA9DC@.microsoft.com...
> hello everybody,
> does anyone knows the max connections the sql server can work with. i need
to know about the sql server capability according to hardware limits ( for
exe:how many connection can the sql manege on 2 cpu's computer with 2.gb
ram, etc')
> thanks
> Ruby

max connections

hello everybody,
does anyone knows the max connections the sql server can work with. i need t
o know about the sql server capability according to hardware limits ( for ex
e:how many connection can the sql manege on 2 cpu's computer with 2.gb ram,
etc')
thanks
RubyHi
The number of connections would be limited by what you are licenced for. If
you are looking for a figure for the number of connections per second this
will mainly be limited by the capabilities of your network, although if you
expect this to be high you should probably be looking at connection pooling.
You should also look at the work carried out by each person as this will
effect the time they are connected and your hardware maybe incapable of
sustaining a reasonable level of service to the users.
For maximum capacity settings see:
8dbn.asp" target="_blank">http://msdn.microsoft.com/library/d...br />
8dbn.asp
Your hardware vendor may be able to give you some idea of what you can
expect and your should specify your requirements as part of the tender
process. This should also allow you to benchmark your application on their
hardware as part of the acceptance process.
John
"ruby" <anonymous@.discussions.microsoft.com> wrote in message
news:9245A3AA-C494-413A-A4B8-6B58C71DA9DC@.microsoft.com...
> hello everybody,
> does anyone knows the max connections the sql server can work with. i need
to know about the sql server capability according to hardware limits ( for
exe:how many connection can the sql manege on 2 cpu's computer with 2.gb
ram, etc')
> thanks
> Rubysql

Saturday, February 25, 2012

match columns and replace according to match..

Hey all,

I used to work with Microsoft Foxpro 6 regularly but now I haven't touched it in months and forgot the proper syntax

I have two databases, they're both the same except that one is outdated. I'd like to match the outdated one up to the good one by product code, and replace all product weights with the newer weight, when the codes match.

foxpro is giving me hell about it though, here's the command I'm trying to execute

-------

repla all prods428.product_we with prods.product_we where prods428.product_co = prods.product_co

--------------

in english, replace all old products weight with new products weight, where old products code equals the new product code..

Any help? I'm sure it's just a minor syntax thing. Thanks in advance :)Hey all,
-------
repla all prods428.product_we with prods.product_we where prods428.product_co = prods.product_co
--------------

in english, replace all old products weight with new products weight, where old products code equals the new product code..

Any help? I'm sure it's just a minor syntax thing. Thanks in advance :)
Now I am not a foxpro guru but I have a hunch that you may want to say repace instead of repla. How's that?|||I'd suggest that you start with the REPLACE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/lngreplace.asp) documentation. Your example looks like you are combining the syntax for REPLACE with SQL syntax, and that VFP is having trouble sorting out what you meant!

-PatP

Friday, March 30, 2012

Max mirroring DB on a 64-bit sysstem?

Max mirroring DB on a 64-bit sysstem?

Max mirroring DB on a 64-bit sysstem?

Max memory for SQL 2000 standard edition

Max memory for SQL 2000 standard edition

Max memory for SQL 2000 standard edition

Monday, March 26, 2012

max connections

max connections

Saturday, February 25, 2012

match columns and replace according to match..

master sysmessages

Blog Archive

About Me