Showing posts with label speak. Show all posts
Showing posts with label speak. Show all posts

Thursday, March 8, 2012

70-431 (MCTS - SQL 2005)

Hi,

Somebody can speak (tips) about exam 70-431?

Tips?

Amount Questions?

Time ?

....

If you're looking for brain dumps this is not the site to get those answers. The 70-431 exam is a 200-level "how-to" exam on all the nuts and bolts of SQL Server 2005. There are free eLearning classes available on the Microsoft web site which will help you with the content information for the test, as well as a number of excellent books hitting the market about now.

I believe you'll get about 40 questions on the test, though it may be higher than that, and you'll get about 2 1/2 hours to answer them.

Go to www.microsoft.com/sql and click on Learning and you'll find out all you need to know to prepare for the test.

Good luck.

|||

What is the passing mark/percentage for MCTS?

|||

Hi Gunny,

is 700 scored.

|||

E X A M S P E C S
Exam Number: 70-431
Active / Retired: Active
Prerequisites:
Exam Format: Multiple-Choice; Multiple Answer
Num Questions: 55
Time Limit: 90
Cost (USD) $: $125
Passing Score: 700

taken from cramsession's site: http://www.cramsession.com/certifications/exams/sql-server-2005.asp?exam_id=770

also use this code for 20% of the exam price

Call now to schedule your Microsoft exam call 1-800-247-8731 and use code MSUU5C7E0100 for your 20% discount.

|||

Many thanks WPH and rkohler.

That's 700 out of how many? What is the max possible score?

|||1000 max scored.|||

Thanks WPH.

|||

any one can respon

i have two server one is dpmain controller and second is exchange 2003 server i need to setup sql 2005

which one i choice ?

|||

a.m.m.e.

Your question really belongs in a separate/new thread. This thread is about MCTS.

But to answer your question, I would advise against putting it on the domain controller. The domain controller contains the Active Directory and security is extremely important. Adding any other role such as SQL Server would complicate security configuration for it.

Actually, if possible, I would set up a new dedicated SQL Server - not add it to the Exchange Server 2003. Mixing multiple roles on one server always complicates security. But if you cannot set up a new dedicated server I would add it to the Exchange Server 2003.

Other more experienced people may have different ideas.

|||

Hello everyone,

I would like to let you all know and be aware of the fact that microsoft has changed its exam pattern for

070-431 be very carefull as microsoft has changed the exam pattern and due to which i failed the exam today.

Its now based on simulations questions which comes after the multiple choice questions i got 15 simulations

separately apart from 35 multi choice questions along with exibits. I wasnt aware of this fact and it wasnt

mentioned ánywhere about simulations questions I think no one knows about it I am the first to face this type of

exam.. The exams comes up with 2 sections the first sections was questions that was 35 in 1hr and the next

was simulations that was 15 2hr 15mins so in total it was 195min exam and I got all correct in first section

and the second section was gred out 60% I got 560 out of 700 may not be difficult but very new.

If in case you have come across with any good site with simulations of this exam please forward me to

a_afroze@.yahoo.com

All the best to all of you

Abdul Afroze

|||

Hello everyone,

I would like to let you all know and be aware of the fact that microsoft has changed its exam pattern for

070-431 be very carefull as microsoft has changed the exam pattern and due to which i failed the exam today.

Its now based on simulations questions which comes after the multiple choice questions i got 15 simulations

separately apart from 35 multi choice questions along with exibits. I wasnt aware of this fact and it wasnt

mentioned ánywhere about simulations questions I think no one knows about it I am the first to face this type of

exam.. The exams comes up with 2 sections the first sections was questions that was 35 in 1hr and the next

was simulations that was 15 2hr 15mins so in total it was 195min exam and I got all correct in first section

and the second section was gred out 60% I got 560 out of 700 may not be difficult but very new.

If in case you have come across with any good site with simulations of this exam please forward me to

a_afroze@.yahoo.com

All the best to all of you

Abdul Afroze

|||

Thanks for the information. I'm going to be taking the test soon and was afraid they would do something like this. They did this to me on the 70-228... completely changed the content and format from what my rather expensive test prep materials were based on.

Could you give us a clue as to what the simulations focused on? (ie. TSQL, SSMS, etc.) I can do just about everything you need to do in SSMS and other GUI tools, but I don't have all the full syntaxes for the TSQL methods memorized (ie. create HTTP endpoint for SOAP vs. TCP endpoint for mirroring).

|||

Well, this really isn't a database documentation request, and using a questions-only site really isn't the best way to go. There are reputable firms, such as Transcender, that will help you with testing and so on. The point is that you should try and learn the trade, rather than just memorizing questions. I've posted an article that deals with certifications:

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=131

And another here dealing with being a DBA. I think you may find those more useful than looking up test questions on a site.

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=247

These are just my thoughts - I do wish you luck in your studies!

|||

Many thanks, Abdul, for that "heads up".

If you or anyone else here come to know of any test exams based on this new pattern I am sure we all would be eager to know about them as soon as possible.

Regards

70-431 (MCTS - SQL 2005)

Hi,

Somebody can speak (tips) about exam 70-431?

Tips?

Amount Questions?

Time ?

....

If you're looking for brain dumps this is not the site to get those answers. The 70-431 exam is a 200-level "how-to" exam on all the nuts and bolts of SQL Server 2005. There are free eLearning classes available on the Microsoft web site which will help you with the content information for the test, as well as a number of excellent books hitting the market about now.

I believe you'll get about 40 questions on the test, though it may be higher than that, and you'll get about 2 1/2 hours to answer them.

Go to www.microsoft.com/sql and click on Learning and you'll find out all you need to know to prepare for the test.

Good luck.

|||

What is the passing mark/percentage for MCTS?

|||

Hi Gunny,

is 700 scored.

|||
E X A M S P E C S
Exam Number: 70-431
Active / Retired: Active
Prerequisites:
Exam Format: Multiple-Choice; Multiple Answer
Num Questions: 55
Time Limit: 90
Cost (USD) $: $125
Passing Score: 700

taken from cramsession's site: http://www.cramsession.com/certifications/exams/sql-server-2005.asp?exam_id=770

also use this code for 20% of the exam price

Call now to schedule your Microsoft exam call 1-800-247-8731 and use code MSUU5C7E0100 for your 20% discount.

|||

Many thanks WPH and rkohler.

That's 700 out of how many? What is the max possible score?

|||1000 max scored.|||

Thanks WPH.

|||

any one can respon

i have two server one is dpmain controller and second is exchange 2003 server i need to setup sql 2005

which one i choice ?

|||

a.m.m.e.

Your question really belongs in a separate/new thread. This thread is about MCTS.

But to answer your question, I would advise against putting it on the domain controller. The domain controller contains the Active Directory and security is extremely important. Adding any other role such as SQL Server would complicate security configuration for it.

Actually, if possible, I would set up a new dedicated SQL Server - not add it to the Exchange Server 2003. Mixing multiple roles on one server always complicates security. But if you cannot set up a new dedicated server I would add it to the Exchange Server 2003.

Other more experienced people may have different ideas.

|||

Hello everyone,

I would like to let you all know and be aware of the fact that microsoft has changed its exam pattern for

070-431 be very carefull as microsoft has changed the exam pattern and due to which i failed the exam today.

Its now based on simulations questions which comes after the multiple choice questions i got 15 simulations

separately apart from 35 multi choice questions along with exibits. I wasnt aware of this fact and it wasnt

mentioned ánywhere about simulations questions I think no one knows about it I am the first to face this type of

exam.. The exams comes up with 2 sections the first sections was questions that was 35 in 1hr and the next

was simulations that was 15 2hr 15mins so in total it was 195min exam and I got all correct in first section

and the second section was gred out 60% I got 560 out of 700 may not be difficult but very new.

If in case you have come across with any good site with simulations of this exam please forward me to

a_afroze@.yahoo.com

All the best to all of you

Abdul Afroze

|||

Hello everyone,

I would like to let you all know and be aware of the fact that microsoft has changed its exam pattern for

070-431 be very carefull as microsoft has changed the exam pattern and due to which i failed the exam today.

Its now based on simulations questions which comes after the multiple choice questions i got 15 simulations

separately apart from 35 multi choice questions along with exibits. I wasnt aware of this fact and it wasnt

mentioned ánywhere about simulations questions I think no one knows about it I am the first to face this type of

exam.. The exams comes up with 2 sections the first sections was questions that was 35 in 1hr and the next

was simulations that was 15 2hr 15mins so in total it was 195min exam and I got all correct in first section

and the second section was gred out 60% I got 560 out of 700 may not be difficult but very new.

If in case you have come across with any good site with simulations of this exam please forward me to

a_afroze@.yahoo.com

All the best to all of you

Abdul Afroze

|||

Thanks for the information. I'm going to be taking the test soon and was afraid they would do something like this. They did this to me on the 70-228... completely changed the content and format from what my rather expensive test prep materials were based on.

Could you give us a clue as to what the simulations focused on? (ie. TSQL, SSMS, etc.) I can do just about everything you need to do in SSMS and other GUI tools, but I don't have all the full syntaxes for the TSQL methods memorized (ie. create HTTP endpoint for SOAP vs. TCP endpoint for mirroring).

|||

Well, this really isn't a database documentation request, and using a questions-only site really isn't the best way to go. There are reputable firms, such as Transcender, that will help you with testing and so on. The point is that you should try and learn the trade, rather than just memorizing questions. I've posted an article that deals with certifications:

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=131

And another here dealing with being a DBA. I think you may find those more useful than looking up test questions on a site.

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=247

These are just my thoughts - I do wish you luck in your studies!

|||

Many thanks, Abdul, for that "heads up".

If you or anyone else here come to know of any test exams based on this new pattern I am sure we all would be eager to know about them as soon as possible.

Regards

70-431 (MCTS - SQL 2005)

Hi,

Somebody can speak (tips) about exam 70-431?

Tips?

Amount Questions?

Time ?

....

If you're looking for brain dumps this is not the site to get those answers. The 70-431 exam is a 200-level "how-to" exam on all the nuts and bolts of SQL Server 2005. There are free eLearning classes available on the Microsoft web site which will help you with the content information for the test, as well as a number of excellent books hitting the market about now.

I believe you'll get about 40 questions on the test, though it may be higher than that, and you'll get about 2 1/2 hours to answer them.

Go to www.microsoft.com/sql and click on Learning and you'll find out all you need to know to prepare for the test.

Good luck.

|||

What is the passing mark/percentage for MCTS?

|||

Hi Gunny,

is 700 scored.

|||

E X A M S P E C S
Exam Number: 70-431
Active / Retired: Active
Prerequisites:
Exam Format: Multiple-Choice; Multiple Answer
Num Questions: 55
Time Limit: 90
Cost (USD) $: $125
Passing Score: 700

taken from cramsession's site: http://www.cramsession.com/certifications/exams/sql-server-2005.asp?exam_id=770

also use this code for 20% of the exam price

Call now to schedule your Microsoft exam call 1-800-247-8731 and use code MSUU5C7E0100 for your 20% discount.

|||

Many thanks WPH and rkohler.

That's 700 out of how many? What is the max possible score?

|||1000 max scored.|||

Thanks WPH.

|||

any one can respon

i have two server one is dpmain controller and second is exchange 2003 server i need to setup sql 2005

which one i choice ?

|||

a.m.m.e.

Your question really belongs in a separate/new thread. This thread is about MCTS.

But to answer your question, I would advise against putting it on the domain controller. The domain controller contains the Active Directory and security is extremely important. Adding any other role such as SQL Server would complicate security configuration for it.

Actually, if possible, I would set up a new dedicated SQL Server - not add it to the Exchange Server 2003. Mixing multiple roles on one server always complicates security. But if you cannot set up a new dedicated server I would add it to the Exchange Server 2003.

Other more experienced people may have different ideas.

|||

Hello everyone,

I would like to let you all know and be aware of the fact that microsoft has changed its exam pattern for

070-431 be very carefull as microsoft has changed the exam pattern and due to which i failed the exam today.

Its now based on simulations questions which comes after the multiple choice questions i got 15 simulations

separately apart from 35 multi choice questions along with exibits. I wasnt aware of this fact and it wasnt

mentioned ánywhere about simulations questions I think no one knows about it I am the first to face this type of

exam.. The exams comes up with 2 sections the first sections was questions that was 35 in 1hr and the next

was simulations that was 15 2hr 15mins so in total it was 195min exam and I got all correct in first section

and the second section was gred out 60% I got 560 out of 700 may not be difficult but very new.

If in case you have come across with any good site with simulations of this exam please forward me to

a_afroze@.yahoo.com

All the best to all of you

Abdul Afroze

|||

Hello everyone,

I would like to let you all know and be aware of the fact that microsoft has changed its exam pattern for

070-431 be very carefull as microsoft has changed the exam pattern and due to which i failed the exam today.

Its now based on simulations questions which comes after the multiple choice questions i got 15 simulations

separately apart from 35 multi choice questions along with exibits. I wasnt aware of this fact and it wasnt

mentioned ánywhere about simulations questions I think no one knows about it I am the first to face this type of

exam.. The exams comes up with 2 sections the first sections was questions that was 35 in 1hr and the next

was simulations that was 15 2hr 15mins so in total it was 195min exam and I got all correct in first section

and the second section was gred out 60% I got 560 out of 700 may not be difficult but very new.

If in case you have come across with any good site with simulations of this exam please forward me to

a_afroze@.yahoo.com

All the best to all of you

Abdul Afroze

|||

Thanks for the information. I'm going to be taking the test soon and was afraid they would do something like this. They did this to me on the 70-228... completely changed the content and format from what my rather expensive test prep materials were based on.

Could you give us a clue as to what the simulations focused on? (ie. TSQL, SSMS, etc.) I can do just about everything you need to do in SSMS and other GUI tools, but I don't have all the full syntaxes for the TSQL methods memorized (ie. create HTTP endpoint for SOAP vs. TCP endpoint for mirroring).

|||

Well, this really isn't a database documentation request, and using a questions-only site really isn't the best way to go. There are reputable firms, such as Transcender, that will help you with testing and so on. The point is that you should try and learn the trade, rather than just memorizing questions. I've posted an article that deals with certifications:

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=131

And another here dealing with being a DBA. I think you may find those more useful than looking up test questions on a site.

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=247

These are just my thoughts - I do wish you luck in your studies!

|||

Many thanks, Abdul, for that "heads up".

If you or anyone else here come to know of any test exams based on this new pattern I am sure we all would be eager to know about them as soon as possible.

Regards

70-431 (MCTS - SQL 2005)

Hi,

Somebody can speak (tips) about exam 70-431?

Tips?

Amount Questions?

Time ?

....

Check out http://www.microsoft.com/learning/exams/70-431.asp

Also check out the following discussion groups @. http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.certification&cat=en_US_9a063422-2f7f-42b6-875e-3e94866bb44f&lang=en&cr=US

Thanks,
Loonysan

70-431 (MCTS - SQL 2005)

Hi,

Somebody can speak (tips) about exam 70-431?

Tips?

Amount Questions?

Time ?

....

If you're looking for brain dumps this is not the site to get those answers. The 70-431 exam is a 200-level "how-to" exam on all the nuts and bolts of SQL Server 2005. There are free eLearning classes available on the Microsoft web site which will help you with the content information for the test, as well as a number of excellent books hitting the market about now.

I believe you'll get about 40 questions on the test, though it may be higher than that, and you'll get about 2 1/2 hours to answer them.

Go to www.microsoft.com/sql and click on Learning and you'll find out all you need to know to prepare for the test.

Good luck.

|||

What is the passing mark/percentage for MCTS?

|||

Hi Gunny,

is 700 scored.

|||

E X A M S P E C S
Exam Number: 70-431
Active / Retired: Active
Prerequisites:
Exam Format: Multiple-Choice; Multiple Answer
Num Questions: 55
Time Limit: 90
Cost (USD) $: $125
Passing Score: 700

taken from cramsession's site: http://www.cramsession.com/certifications/exams/sql-server-2005.asp?exam_id=770

also use this code for 20% of the exam price

Call now to schedule your Microsoft exam call 1-800-247-8731 and use code MSUU5C7E0100 for your 20% discount.

|||

Many thanks WPH and rkohler.

That's 700 out of how many? What is the max possible score?

|||1000 max scored.|||

Thanks WPH.

|||

any one can respon

i have two server one is dpmain controller and second is exchange 2003 server i need to setup sql 2005

which one i choice ?

|||

a.m.m.e.

Your question really belongs in a separate/new thread. This thread is about MCTS.

But to answer your question, I would advise against putting it on the domain controller. The domain controller contains the Active Directory and security is extremely important. Adding any other role such as SQL Server would complicate security configuration for it.

Actually, if possible, I would set up a new dedicated SQL Server - not add it to the Exchange Server 2003. Mixing multiple roles on one server always complicates security. But if you cannot set up a new dedicated server I would add it to the Exchange Server 2003.

Other more experienced people may have different ideas.

|||

Hello everyone,

I would like to let you all know and be aware of the fact that microsoft has changed its exam pattern for

070-431 be very carefull as microsoft has changed the exam pattern and due to which i failed the exam today.

Its now based on simulations questions which comes after the multiple choice questions i got 15 simulations

separately apart from 35 multi choice questions along with exibits. I wasnt aware of this fact and it wasnt

mentioned ánywhere about simulations questions I think no one knows about it I am the first to face this type of

exam.. The exams comes up with 2 sections the first sections was questions that was 35 in 1hr and the next

was simulations that was 15 2hr 15mins so in total it was 195min exam and I got all correct in first section

and the second section was gred out 60% I got 560 out of 700 may not be difficult but very new.

If in case you have come across with any good site with simulations of this exam please forward me to

a_afroze@.yahoo.com

All the best to all of you

Abdul Afroze

|||

Hello everyone,

I would like to let you all know and be aware of the fact that microsoft has changed its exam pattern for

070-431 be very carefull as microsoft has changed the exam pattern and due to which i failed the exam today.

Its now based on simulations questions which comes after the multiple choice questions i got 15 simulations

separately apart from 35 multi choice questions along with exibits. I wasnt aware of this fact and it wasnt

mentioned ánywhere about simulations questions I think no one knows about it I am the first to face this type of

exam.. The exams comes up with 2 sections the first sections was questions that was 35 in 1hr and the next

was simulations that was 15 2hr 15mins so in total it was 195min exam and I got all correct in first section

and the second section was gred out 60% I got 560 out of 700 may not be difficult but very new.

If in case you have come across with any good site with simulations of this exam please forward me to

a_afroze@.yahoo.com

All the best to all of you

Abdul Afroze

|||

Thanks for the information. I'm going to be taking the test soon and was afraid they would do something like this. They did this to me on the 70-228... completely changed the content and format from what my rather expensive test prep materials were based on.

Could you give us a clue as to what the simulations focused on? (ie. TSQL, SSMS, etc.) I can do just about everything you need to do in SSMS and other GUI tools, but I don't have all the full syntaxes for the TSQL methods memorized (ie. create HTTP endpoint for SOAP vs. TCP endpoint for mirroring).

|||

Well, this really isn't a database documentation request, and using a questions-only site really isn't the best way to go. There are reputable firms, such as Transcender, that will help you with testing and so on. The point is that you should try and learn the trade, rather than just memorizing questions. I've posted an article that deals with certifications:

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=131

And another here dealing with being a DBA. I think you may find those more useful than looking up test questions on a site.

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=247

These are just my thoughts - I do wish you luck in your studies!

|||

Many thanks, Abdul, for that "heads up".

If you or anyone else here come to know of any test exams based on this new pattern I am sure we all would be eager to know about them as soon as possible.

Regards

Thursday, February 16, 2012

5, 8 or 25 concurents workloads ?

Hello,
I'm usng MSDE2000A (not MSDE2000)
The MSDE2000 documentation speak about 5 concurents
operations limitation.
The "Approriate uses of MSDE Faq" speak about 25
concurents users (means concurents operations?)
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
(see the "Can I use MSDE as a database for Web
applications?" question)
The SQL Server 2000 Workload Governor speak about 8
concurents operations
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Who's right? What's the exact number limitation for
MSDE2000A? 8 or 5 or 25 ?
Thanks for reply.
Georges
Thanks for posting this question...
I was myself confused after reading all this.. but after clarification from many posts out here, it seems that the workload governer kicks in after 5 concurrent operations (3 are reserved for the system, so total is 8)..
But the verdict of the people using MSDE is that it seems to work fairly well even if the number of concurrent operations goes till 25 and above.. you'll just have to test you system.
Hope it helps.
dev
"Georges" wrote:

> Hello,
> I'm usng MSDE2000A (not MSDE2000)
> The MSDE2000 documentation speak about 5 concurents
> operations limitation.
> The "Approriate uses of MSDE Faq" speak about 25
> concurents users (means concurents operations?)
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
> (see the "Can I use MSDE as a database for Web
> applications?" question)
> The SQL Server 2000 Workload Governor speak about 8
> concurents operations
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
> Who's right? What's the exact number limitation for
> MSDE2000A? 8 or 5 or 25 ?
> Thanks for reply.
> Georges
>
|||The governor is intended to kick in when there are 5 concurrent *USER*
workloads (a workload is NOT the same concept as a user/connection).
The 8 that you see referenced is because there are 3 workloads allotted for
system activity (designed so that the system can continue to do work even if
5 workloads are tying up the system).
The 25 that you see referenced is 25 concurrent users, not concurrent
workloads. Even with 25 users connected to the database, it is unlikely ,
unless you have really inefficient queries (in which case you probably won't
notice the governor anyway). As dev_kh stated, you'll have to test your
system to see if (a) the governor kicks in at all, and (b) whether its
effect is tolerable.
http://msdn.microsoft.com/library/en...r_sa2_0ciq.asp
All of this confusion is one of the primary reasons the governor was removed
in SQL Server 2005 Express, I think.
http://www.aspfaq.com/
(Reverse address to reply.)
"Georges" <anonymous@.discussions.microsoft.com> wrote in message
news:133701c46f12$14ae53c0$a501280a@.phx.gbl...
> Hello,
> I'm usng MSDE2000A (not MSDE2000)
> The MSDE2000 documentation speak about 5 concurents
> operations limitation.
> The "Approriate uses of MSDE Faq" speak about 25
> concurents users (means concurents operations?)
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
> (see the "Can I use MSDE as a database for Web
> applications?" question)
> The SQL Server 2000 Workload Governor speak about 8
> concurents operations
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
> Who's right? What's the exact number limitation for
> MSDE2000A? 8 or 5 or 25 ?
> Thanks for reply.
> Georges
|||I thought that MSDE had a limit of 10 concurrent users? Is it 25?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23q8AjzybEHA.2660@.TK2MSFTNGP12.phx.gbl...
> The governor is intended to kick in when there are 5 concurrent *USER*
> workloads (a workload is NOT the same concept as a user/connection).
> The 8 that you see referenced is because there are 3 workloads allotted
for
> system activity (designed so that the system can continue to do work even
if
> 5 workloads are tying up the system).
> The 25 that you see referenced is 25 concurrent users, not concurrent
> workloads. Even with 25 users connected to the database, it is unlikely ,
> unless you have really inefficient queries (in which case you probably
won't
> notice the governor anyway). As dev_kh stated, you'll have to test your
> system to see if (a) the governor kicks in at all, and (b) whether its
> effect is tolerable.
> http://msdn.microsoft.com/library/en...r_sa2_0ciq.asp
> All of this confusion is one of the primary reasons the governor was
removed
> in SQL Server 2005 Express, I think.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Georges" <anonymous@.discussions.microsoft.com> wrote in message
> news:133701c46f12$14ae53c0$a501280a@.phx.gbl...
>
|||> I thought that MSDE had a limit of 10 concurrent users? Is it 25?
No, it is neither. As I tried to explain, MSDE doesn't have a limit on
concurrent users at all (not 5, not 8, not 10, not 25, not 5000). There is
a governor that throttles performance at or around 5 simultaneous workloads,
which is *NOT* the same as a connection.
The 25 was a *suggestion* on one of the product pages, for how many
concurrent users a typical system running MSDE could support. This could be
completely different from project to project, as hardware, application code,
usage, bandwidth, database design etc. can differ, and all of these things
impact how an application performs. So you will need to test it out to see
how many simultaneous users and/or workloads your specific scenario can
support.
To provide an analogy for the difference between a concurrent user and a
concurrent workload. Imagine yourself at the DMV, and there are 40 people
waiting around, not doing much. Two people are at the registration counter,
and one person is getting her picture taken for a new drivers' license. The
40 people are "concurrent users" and the other three are "concurrent
workloads" - since they're the only ones actually doing anything productive.
http://www.aspfaq.com/
(Reverse address to reply.)
|||ahhh - thanks!
love the DMV analogy, btw :-)
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23Bqzmw%23bEHA.1144@.TK2MSFTNGP11.phx.gbl...
> No, it is neither. As I tried to explain, MSDE doesn't have a limit on
> concurrent users at all (not 5, not 8, not 10, not 25, not 5000). There
is
> a governor that throttles performance at or around 5 simultaneous
workloads,
> which is *NOT* the same as a connection.
> The 25 was a *suggestion* on one of the product pages, for how many
> concurrent users a typical system running MSDE could support. This could
be
> completely different from project to project, as hardware, application
code,
> usage, bandwidth, database design etc. can differ, and all of these things
> impact how an application performs. So you will need to test it out to
see
> how many simultaneous users and/or workloads your specific scenario can
> support.
> To provide an analogy for the difference between a concurrent user and a
> concurrent workload. Imagine yourself at the DMV, and there are 40 people
> waiting around, not doing much. Two people are at the registration
counter,
> and one person is getting her picture taken for a new drivers' license.
The
> 40 people are "concurrent users" and the other three are "concurrent
> workloads" - since they're the only ones actually doing anything
productive.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
|||> love the DMV analogy, btw :-)
Yeah, I was hoping you were in the US; most others wouldn't get it. ;-)
http://www.aspfaq.com/
(Reverse address to reply.)
|||> most others wouldn't get it. ;-)
Just to be clear, I don't mean the concept (I think it's pretty clear even
if you replace DMV with McDonald's or the tax office or your human resources
department).
I mean the irony of talking about the DMV in terms of performance and
workload governing. Most of the locations I have been to have an unlimited
concurrent user threshold, but the staff has a concurrent workload limit of
exactly 1. ;-)
A