One general q?

Helo all,
i have one general q about sql server and MSDE.
for how many users can i configure MSDE to work for?
i mean connection per second, or something like that?
thanks in advance!
-k.p.
There is no such config in MSDE. Just leave the sp_configure settings as they are. MSDE is
throttled, when you have more than 5.8 queries *executing at the same time* a delay is introduced
for each I/O operation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.
|||There is no hard limit for the number of users that can connect to MSDE, but
as a rule of thumb you can assume that performance will degrade with more
than about 20 users connected concurrently.
Jacco Schalkwijk
SQL Server MVP
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.
|||Thanx Tibor and Jacco for reply!
"gorostas" wrote:

> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.
|||http://www.aspfaq.com/2343
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.

One general q?

Helo all,
i have one general q about sql server and MSDE.
for how many users can i configure MSDE to work for?
i mean connection per second, or something like that?
thanks in advance!
-k.p.There is no such config in MSDE. Just leave the sp_configure settings as the
y are. MSDE is
throttled, when you have more than 5.8 queries *executing at the same time*
a delay is introduced
for each I/O operation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.|||There is no hard limit for the number of users that can connect to MSDE, but
as a rule of thumb you can assume that performance will degrade with more
than about 20 users connected concurrently.
Jacco Schalkwijk
SQL Server MVP
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.|||Thanx Tibor and Jacco for reply!
"gorostas" wrote:

> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.|||http://www.aspfaq.com/2343
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.

One general q?

Helo all,
i have one general q about sql server and MSDE.
for how many users can i configure MSDE to work for?
i mean connection per second, or something like that?
thanks in advance!
-k.p.There is no such config in MSDE. Just leave the sp_configure settings as they are. MSDE is
throttled, when you have more than 5.8 queries *executing at the same time* a delay is introduced
for each I/O operation.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.|||There is no hard limit for the number of users that can connect to MSDE, but
as a rule of thumb you can assume that performance will degrade with more
than about 20 users connected concurrently.
--
Jacco Schalkwijk
SQL Server MVP
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.|||Thanx Tibor and Jacco for reply!
"gorostas" wrote:
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.|||http://www.aspfaq.com/2343
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.

one configure file for all my package.

Hi,

How can i create one configure file that all my packages will inherit the connection to other databases from him?

thanks.

what is better to save my connection string into a table in my DWH or save them to XML file,

so when i want to change my SSIS to work with test enviroment it take the connection string from the db and when i want to switch to prod enviroment i'll use the connection of prod that store in the db.

i think to create a package will switch the connection string value whenever i want?

is it the right way ?

any ideas?

thanks alot!

|||Use of the database or XML is mostly a matter of personal preference. An additional step that is required with a database configuration is managing connections to the configuration database itself. You usually need a seperate XML configuration (or a variable that you set via the commandline) to handle the connection for the configuration database.

OLE DB for ODBC connections in BIDS/AS project

Hi,

I try to configure a new data source in my Analysis Services Project in BIDS and I would like to test the OLE DB for ODBC Provider, but I cannot find it, although it is definitely installed on the box.

Is this kind of connection not allowed or not supported for AS?

Norbert

I'm pretty certain that it's not supported for AS2005.

Sorry,

Chris

|||

Indeed the OLEDB for ODBC provider is not supported by Analysis Services 2005.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.