friends,
I m in a process of makin a website tat will store the vital
statistics of users.Users can turn out to be in millions!!!
Can u help me to kno how much space will tat take and how much space
should i book online to keep my site in wrkin condition.
Ur help sought.
Thanx
samraatWithout table definitions (Including indexes) that would be impossible.
100 milllion users at an average of 8 bytes per row is small
100 million users at an average of 7800 bytes per row with 70 indexes most of them compound could be nasty.
Like I said, without definitions the permetations are endless.
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org|||samabhik,
> I m in a process of makin a website tat will store the vital
> statistics of users.Users can turn out to be in millions!!!
> Can u help me to kno how much space will tat take and how much
> space should i book online to keep my site in wrkin condition.
Once you have your schema, you can calculate how much space you will
need. Refer to the topic Estimating Database Size in Books Online
for an example.
Linda
Showing posts with label website. Show all posts
Showing posts with label website. Show all posts
Wednesday, March 28, 2012
Monday, March 19, 2012
how many concurrent users for client/server app?
How many concurrent users will MSDE support in a client/server application?
I found 25 users for a website but I have an Access application that I wish
to connect to MSDE and wish to know how many users before having to upgrade
to the full blown version of SQL Server.
hi Ron,
Ron wrote:
> How many concurrent users will MSDE support in a client/server
> application? I found 25 users for a website but I have an Access
> application that I wish to connect to MSDE and wish to know how many
> users before having to upgrade to the full blown version of SQL
> Server.
25 concurrent users is just am estimate number, as it depend on the actual
project , the dataload, the data access type, the data access method and so
on...
you really have to test yourself for your actual solution..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I found 25 users for a website but I have an Access application that I wish
to connect to MSDE and wish to know how many users before having to upgrade
to the full blown version of SQL Server.
hi Ron,
Ron wrote:
> How many concurrent users will MSDE support in a client/server
> application? I found 25 users for a website but I have an Access
> application that I wish to connect to MSDE and wish to know how many
> users before having to upgrade to the full blown version of SQL
> Server.
25 concurrent users is just am estimate number, as it depend on the actual
project , the dataload, the data access type, the data access method and so
on...
you really have to test yourself for your actual solution..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
How many CALs for a web page?
Is there any way to know aprox. how many cals a DB should have for an
avg website. I don't really know how many concurrent users there will
be.Hi
avg website. I don't really know how many concurrent users there will
be.Hi
You would need to confirm this with you software supplier, but I think you
should be looking for a processor licence rather than CAL see
http://www.microsoft.com/sql/howtob...rlicensing.mspx
John
<wackyphill@.yahoo.com> wrote in message
news:1135697473.411563.197280@.g43g2000cwa.googlegr oups.com...
> Is there any way to know aprox. how many cals a DB should have for an
> avg website. I don't really know how many concurrent users there will
> be.|||wackyphill@.yahoo.com wrote:
> Is there any way to know aprox. how many cals a DB should have for an
> avg website. I don't really know how many concurrent users there will
> be.
For a public site you need a processor licence. (likely cheaper than a
CAL per visitor anyway!)
See:
http://www.microsoft.com/sql/howtobuy/default.mspx
--
David Portas
SQL Server MVP
--|||You'll need to liecence per physical processor in the box you are running
SQL on.
Alternatively, you could look at using SQL 2005 Express edition which you
can use for free but it has some limitations, check out
http://microsoft.com/sql for more information.
--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
<wackyphill@.yahoo.com> wrote in message
news:1135697473.411563.197280@.g43g2000cwa.googlegr oups.com...
> Is there any way to know aprox. how many cals a DB should have for an
> avg website. I don't really know how many concurrent users there will
> be.
Friday, March 9, 2012
How log a Bug case?
Does Microsoft have a website (or phone number) to log a bug case?
I'm not sure if this should be filed under SQL Server or ACT5.0.
The problem we stumbled across was that the ACT5.0 install creates a
Version table in the master database. This kept our Desktop
Integration group from using ACT when we did a server switch from one
SQL Server to it's standby server.
It was only though a vague reference from a internet search that we
found a mention of this table in the master database.
I believe this to be a bug, probably in ACT50, that the install is
doing this.
Any help would be great.
Thanks,
JoeyDYes, that sounds like a problem with ACT5.0. Logically, if it knows about a
standby server, it should make sure it has relevant objects in that server.
How is SQL Server supposed to know about the application's needs?
"JoeyD" <joeydba@.gmail.com> wrote in message
news:b9f5e14c-bc11-4aba-a34b-5c21c5235c9f@.k13g2000hse.googlegroups.com...
> Does Microsoft have a website (or phone number) to log a bug case?
> I'm not sure if this should be filed under SQL Server or ACT5.0.
> The problem we stumbled across was that the ACT5.0 install creates a
> Version table in the master database. This kept our Desktop
> Integration group from using ACT when we did a server switch from one
> SQL Server to it's standby server.
> It was only though a vague reference from a internet search that we
> found a mention of this table in the master database.
> I believe this to be a bug, probably in ACT50, that the install is
> doing this.
> Any help would be great.
> Thanks,
> JoeyD
>
>|||The place to report bugs for Microsoft products is Connect:
http://connect.microsoft.com/
Roy Harvey
Beacon Falls, CT
On Mon, 28 Apr 2008 13:40:00 -0700 (PDT), JoeyD <joeydba@.gmail.com>
wrote:
>Does Microsoft have a website (or phone number) to log a bug case?
>I'm not sure if this should be filed under SQL Server or ACT5.0.
>The problem we stumbled across was that the ACT5.0 install creates a
>Version table in the master database. This kept our Desktop
>Integration group from using ACT when we did a server switch from one
>SQL Server to it's standby server.
>It was only though a vague reference from a internet search that we
>found a mention of this table in the master database.
>I believe this to be a bug, probably in ACT50, that the install is
>doing this.
>Any help would be great.
>Thanks,
>JoeyD
>|||Roy - thank you very much. That is what I was looking for.
Have a good day.
JoeyD|||> Roy - thank you very much. That is what I was looking for.
> Have a good day.
So you're going to file a bug in Connect, against SQL Server, that ACT
doesn't properly initialize its standby database?|||Wait, is ACT the Application Compatibility Toolkit, or the contact
management tool from www.act.com?
"JoeyD" <joeydba@.gmail.com> wrote in message
news:8817ebba-1fca-4005-87f0-c269a6cc702a@.m44g2000hsc.googlegroups.com...
> Roy - thank you very much. That is what I was looking for.
> Have a good day.
> JoeyD|||On Tue, 29 Apr 2008 09:32:39 -0400, "Aaron Bertrand [SQL Server MVP]"
<ten.xoc@.dnartreb.noraa> wrote:
>Wait, is ACT the Application Compatibility Toolkit, or the contact
>management tool from www.act.com?
My guess was the Application Compatibility Toolkit simply because it
seems to be at release 5.0.
Roy Harvey
Beacon Falls, CT|||> My guess was the Application Compatibility Toolkit simply because it
> seems to be at release 5.0.
Even still, is there a connect area for that tool? Certainly its
shortcomings are not a SQL Server problem. :-)|||Hi All - I'll log the bug against ACT (Application Compatibility
Toolkit).
It's just never ceases to amaze me how the left hand doesn't know what
the right hand is doing. In this case, both are MS products, and for
decades I've been taught, instructed,..., that we should not be
putting users tables into any of the systems databases.
thank you all for your help and suggestions.
JoeyD|||On Tue, 29 Apr 2008 10:19:15 -0400, "Aaron Bertrand [SQL Server MVP]"
<ten.xoc@.dnartreb.noraa> wrote:
>> My guess was the Application Compatibility Toolkit simply because it
>> seems to be at release 5.0.
>Even still, is there a connect area for that tool? Certainly its
>shortcomings are not a SQL Server problem. :-)
No, but it sounds like at least one shortcoming might become a SQL
Server DBA's problem!
Roy Harvey
Beacon Falls, CT
I'm not sure if this should be filed under SQL Server or ACT5.0.
The problem we stumbled across was that the ACT5.0 install creates a
Version table in the master database. This kept our Desktop
Integration group from using ACT when we did a server switch from one
SQL Server to it's standby server.
It was only though a vague reference from a internet search that we
found a mention of this table in the master database.
I believe this to be a bug, probably in ACT50, that the install is
doing this.
Any help would be great.
Thanks,
JoeyDYes, that sounds like a problem with ACT5.0. Logically, if it knows about a
standby server, it should make sure it has relevant objects in that server.
How is SQL Server supposed to know about the application's needs?
"JoeyD" <joeydba@.gmail.com> wrote in message
news:b9f5e14c-bc11-4aba-a34b-5c21c5235c9f@.k13g2000hse.googlegroups.com...
> Does Microsoft have a website (or phone number) to log a bug case?
> I'm not sure if this should be filed under SQL Server or ACT5.0.
> The problem we stumbled across was that the ACT5.0 install creates a
> Version table in the master database. This kept our Desktop
> Integration group from using ACT when we did a server switch from one
> SQL Server to it's standby server.
> It was only though a vague reference from a internet search that we
> found a mention of this table in the master database.
> I believe this to be a bug, probably in ACT50, that the install is
> doing this.
> Any help would be great.
> Thanks,
> JoeyD
>
>|||The place to report bugs for Microsoft products is Connect:
http://connect.microsoft.com/
Roy Harvey
Beacon Falls, CT
On Mon, 28 Apr 2008 13:40:00 -0700 (PDT), JoeyD <joeydba@.gmail.com>
wrote:
>Does Microsoft have a website (or phone number) to log a bug case?
>I'm not sure if this should be filed under SQL Server or ACT5.0.
>The problem we stumbled across was that the ACT5.0 install creates a
>Version table in the master database. This kept our Desktop
>Integration group from using ACT when we did a server switch from one
>SQL Server to it's standby server.
>It was only though a vague reference from a internet search that we
>found a mention of this table in the master database.
>I believe this to be a bug, probably in ACT50, that the install is
>doing this.
>Any help would be great.
>Thanks,
>JoeyD
>|||Roy - thank you very much. That is what I was looking for.
Have a good day.
JoeyD|||> Roy - thank you very much. That is what I was looking for.
> Have a good day.
So you're going to file a bug in Connect, against SQL Server, that ACT
doesn't properly initialize its standby database?|||Wait, is ACT the Application Compatibility Toolkit, or the contact
management tool from www.act.com?
"JoeyD" <joeydba@.gmail.com> wrote in message
news:8817ebba-1fca-4005-87f0-c269a6cc702a@.m44g2000hsc.googlegroups.com...
> Roy - thank you very much. That is what I was looking for.
> Have a good day.
> JoeyD|||On Tue, 29 Apr 2008 09:32:39 -0400, "Aaron Bertrand [SQL Server MVP]"
<ten.xoc@.dnartreb.noraa> wrote:
>Wait, is ACT the Application Compatibility Toolkit, or the contact
>management tool from www.act.com?
My guess was the Application Compatibility Toolkit simply because it
seems to be at release 5.0.
Roy Harvey
Beacon Falls, CT|||> My guess was the Application Compatibility Toolkit simply because it
> seems to be at release 5.0.
Even still, is there a connect area for that tool? Certainly its
shortcomings are not a SQL Server problem. :-)|||Hi All - I'll log the bug against ACT (Application Compatibility
Toolkit).
It's just never ceases to amaze me how the left hand doesn't know what
the right hand is doing. In this case, both are MS products, and for
decades I've been taught, instructed,..., that we should not be
putting users tables into any of the systems databases.
thank you all for your help and suggestions.
JoeyD|||On Tue, 29 Apr 2008 10:19:15 -0400, "Aaron Bertrand [SQL Server MVP]"
<ten.xoc@.dnartreb.noraa> wrote:
>> My guess was the Application Compatibility Toolkit simply because it
>> seems to be at release 5.0.
>Even still, is there a connect area for that tool? Certainly its
>shortcomings are not a SQL Server problem. :-)
No, but it sounds like at least one shortcoming might become a SQL
Server DBA's problem!
Roy Harvey
Beacon Falls, CT
Subscribe to:
Posts (Atom)