how much size SQL SERVER each connection memory ?

recently ,I got about15M size to each db connection memory with
windows performance monitor,
I want to know is this normal?
I heard that each normal connection is about 2M size,is this right?
best regards!If you check this on BOL, it will give you a general idea of how much
memory Sql server uses for a object.
"Memory Used by SQL Server Objects Specifications"
Mel|||thanks ,but what 's BOL,can you tell me?|||SQL Server Books Online, the documentation that comes with SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<lovexueer@.gmail.com> wrote in message news:1144320352.630105.194670@.z34g2000cwc.googlegroup
s.com...
> thanks ,but what 's BOL,can you tell me?
>

how much size SQL SERVER each connection memory ?

recently ,I got about15M size to each db connection memory with
windows performance monitor,
I want to know is this normal?
I heard that each normal connection is about 2M size,is this right?
best regards!
If you check this on BOL, it will give you a general idea of how much
memory Sql server uses for a object.
"Memory Used by SQL Server Objects Specifications"
Mel
|||thanks ,but what 's BOL,can you tell me?
|||SQL Server Books Online, the documentation that comes with SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<lovexueer@.gmail.com> wrote in message news:1144320352.630105.194670@.z34g2000cwc.googlegr oups.com...
> thanks ,but what 's BOL,can you tell me?
>
sql

how much size SQL SERVER each connection memory ?

recently ,I got about15M size to each db connection memory with
windows performance monitor,
I want to know is this normal?
I heard that each normal connection is about 2M size,is this right?
best regards!If you check this on BOL, it will give you a general idea of how much
memory Sql server uses for a object.
"Memory Used by SQL Server Objects Specifications"
Mel|||thanks ,but what 's BOL,can you tell me?|||SQL Server Books Online, the documentation that comes with SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<lovexueer@.gmail.com> wrote in message news:1144320352.630105.194670@.z34g2000cwc.googlegroups.com...
> thanks ,but what 's BOL,can you tell me?
>

How much memory is allotted to a single user connection?

Hi, everybody!
I wonder how much memory space is allotted to a single user connection.
I know MS SQL Server 6.5 allots 37KB of memory space to a single connection.
And I heard that MS SQL 2000 allots 500KB of memory space to a single
connection.
Is it true?
Thanks in advance.Where did u get this stat from ... Will be interested to see the same ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
"Kim Keuk Tae" <zyuuzika@.korea.com> wrote in message
news:OevJwlqlDHA.2432@.TK2MSFTNGP10.phx.gbl...
> Hi, everybody!
> I wonder how much memory space is allotted to a single user connection.
> I know MS SQL Server 6.5 allots 37KB of memory space to a single
connection.
> And I heard that MS SQL 2000 allots 500KB of memory space to a single
> connection.
> Is it true?
> Thanks in advance.
>
>|||When in doubt, always first check the BOL. Under the section "Memory used by
SQL Server 2000 Objects Specifications", the BOL indicates that:
The memory used by a use connection uses 12 KB + (3 * Network Packet Size),
where Network Packet Size is controlled by the 'network packet size'
configuration option. The default is 4KB.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Kim Keuk Tae" <zyuuzika@.korea.com> wrote in message
news:OevJwlqlDHA.2432@.TK2MSFTNGP10.phx.gbl...
> Hi, everybody!
> I wonder how much memory space is allotted to a single user connection.
> I know MS SQL Server 6.5 allots 37KB of memory space to a single
connection.
> And I heard that MS SQL 2000 allots 500KB of memory space to a single
> connection.
> Is it true?
> Thanks in advance.
>
>

how many connection sqlexpress supports

I see this question a lot, so I thought I would go ahead and post the answer here.

Q: How many connections does SQL Server Express support?

A: Unlike MSDE, SQL Server Express does not limit connections. SQL Server Express supports:

1 gb RAM (note the machine can have more memory, but 1gb will be used by SQL Express) 1 processor (again, the machine can have more, but just 1 proc will be used by SQL Express) 4 gb database size (note, there can be multiple databases, but none of them individually can be more than 4 gb)

Hope this helps,

Thanks< MJ

Is it right that only 5 database users can connect to SQL Server express 2005 engine at the same time?

how make public sql connection

hi,
i want to make a sql connection for a simple application
but i want to use this same connection in the application i have 10 forms in
application so i want in all forms.
after i make setup i can i should change the server name and password.
so if this possible please tell me about this in details.
thanks.
mitesh
This connection works well for me:
Sub InsertData()
Dim oConn As Object
Dim sSQL As String
Application.ScreenUpdating = False
Set wsSheet = ActiveWorkbook.Sheets("Product Tracking")
Set oConn = CreateObject("ADODB.Connection")
oConn.Open = "Provider=sqloledb;" & _
"Data Source=xx.x.xx.xx;" & _
"Initial Catalog=xxx_xxx;" & _
"User Id=xxxx;" & _
"Password=xxxx"
sSQL = "INSERT INTO Upload_Specific " & _
"([Location], [Product Type], [Quantity], [Product Name], [Style],
[Features]) " & _
" VALUES ('" & Range("A2").Value & "', '" & Range("B2").Value & "', '" &
Range("C2").Value & "', '" & Range("D2").Value & "', '" & Range("E2").Value
& "', '" & _
Range("F2").Value & "')"
oConn.Execute sSQL
oConn.Close
Set oConn = Nothing
End Sub
HTH
"mitesh" <mitesh@.discussions.microsoft.com> wrote in message
news:F5513C08-228E-4AE5-A5CC-A8AA574DA6DB@.microsoft.com...
> hi,
> i want to make a sql connection for a simple application
> but i want to use this same connection in the application i have 10 forms
> in
> application so i want in all forms.
> after i make setup i can i should change the server name and password.
> so if this possible please tell me about this in details.
> thanks.
> mitesh

how make public sql connection

hi,
i want to make a sql connection for a simple application
but i want to use this same connection in the application i have 10 forms in
application so i want in all forms.
after i make setup i can i should change the server name and password.
so if this possible please tell me about this in details.
thanks.
miteshThis connection works well for me:
Sub InsertData()
Dim oConn As Object
Dim sSQL As String
Application.ScreenUpdating = False
Set wsSheet = ActiveWorkbook.Sheets("Product Tracking")
Set oConn = CreateObject("ADODB.Connection")
oConn.Open = "Provider=sqloledb;" & _
"Data Source=xx.x.xx.xx;" & _
"Initial Catalog=xxx_xxx;" & _
"User Id=xxxx;" & _
"Password=xxxx"
sSQL = "INSERT INTO Upload_Specific " & _
"([Location], [Product Type], [Quantity], [Product Name], &#
91;Style],
[Features]) " & _
" VALUES ('" & Range("A2").Value & "', '" & Range("B2").Value & "', '" &
Range("C2").Value & "', '" & Range("D2").Value & "', '" & Range("E2").Value
& "', '" & _
Range("F2").Value & "')"
oConn.Execute sSQL
oConn.Close
Set oConn = Nothing
End Sub
HTH
"mitesh" <mitesh@.discussions.microsoft.com> wrote in message
news:F5513C08-228E-4AE5-A5CC-A8AA574DA6DB@.microsoft.com...
> hi,
> i want to make a sql connection for a simple application
> but i want to use this same connection in the application i have 10 forms
> in
> application so i want in all forms.
> after i make setup i can i should change the server name and password.
> so if this possible please tell me about this in details.
> thanks.
> mitesh

how long before sleeping connections disappear

Using SS2000 SP4. How long does it take after a user logs out before their
"sleeping connection" in EM/Current Activity/Process Info disappears? Is
there a way short of rebooting or stopping/starting services to get it to
disappear sooner?
Thanks,
--
Dan D.Hello,
The inactive connections will be removed from SQL Server based on the
application time out setup in appllication layer. Sleeping status doesnt
mean that status is orphan
connection, because most of the time if the process wait for a user Input
or waiting for a lock will be in sleeping mode. It can go for Running
status any time.
Take a look into the below URL:-
http://support.microsoft.com/kb/Q137983
Thanks
Hari
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.|||The connections are held until the application closes them. Many
applications use connection pooling so that closed connections are pooled
for reuse. These will disappear after a short period, IIRC 30-60 seconds.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.|||These connections are persisting longer than that. Maybe the application has
changed the timeout. Thanks.
--
Dan D.
"Dan Guzman" wrote:
> The connections are held until the application closes them. Many
> applications use connection pooling so that closed connections are pooled
> for reuse. These will disappear after a short period, IIRC 30-60 seconds.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> > Using SS2000 SP4. How long does it take after a user logs out before their
> > "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> > there a way short of rebooting or stopping/starting services to get it to
> > disappear sooner?
> >
> > Thanks,
> > --
> > Dan D.
>|||Interesting article. Thanks.
--
Dan D.
"Hari Prasad" wrote:
> Hello,
> The inactive connections will be removed from SQL Server based on the
> application time out setup in appllication layer. Sleeping status doesnt
> mean that status is orphan
> connection, because most of the time if the process wait for a user Input
> or waiting for a lock will be in sleeping mode. It can go for Running
> status any time.
> Take a look into the below URL:-
> http://support.microsoft.com/kb/Q137983
> Thanks
> Hari
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> > Using SS2000 SP4. How long does it take after a user logs out before their
> > "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> > there a way short of rebooting or stopping/starting services to get it to
> > disappear sooner?
> >
> > Thanks,
> > --
> > Dan D.
>
>

how long before sleeping connections disappear

Using SS2000 SP4. How long does it take after a user logs out before their
"sleeping connection" in EM/Current Activity/Process Info disappears? Is
there a way short of rebooting or stopping/starting services to get it to
disappear sooner?
Thanks,
Dan D.
Hello,
The inactive connections will be removed from SQL Server based on the
application time out setup in appllication layer. Sleeping status doesnt
mean that status is orphan
connection, because most of the time if the process wait for a user Input
or waiting for a lock will be in sleeping mode. It can go for Running
status any time.
Take a look into the below URL:-
http://support.microsoft.com/kb/Q137983
Thanks
Hari
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.
|||The connections are held until the application closes them. Many
applications use connection pooling so that closed connections are pooled
for reuse. These will disappear after a short period, IIRC 30-60 seconds.
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.
|||These connections are persisting longer than that. Maybe the application has
changed the timeout. Thanks.
Dan D.
"Dan Guzman" wrote:

> The connections are held until the application closes them. Many
> applications use connection pooling so that closed connections are pooled
> for reuse. These will disappear after a short period, IIRC 30-60 seconds.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
>
|||Interesting article. Thanks.
Dan D.
"Hari Prasad" wrote:

> Hello,
> The inactive connections will be removed from SQL Server based on the
> application time out setup in appllication layer. Sleeping status doesnt
> mean that status is orphan
> connection, because most of the time if the process wait for a user Input
> or waiting for a lock will be in sleeping mode. It can go for Running
> status any time.
> Take a look into the below URL:-
> http://support.microsoft.com/kb/Q137983
> Thanks
> Hari
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
>
>

how long before sleeping connections disappear

Using SS2000 SP4. How long does it take after a user logs out before their
"sleeping connection" in EM/Current Activity/Process Info disappears? Is
there a way short of rebooting or stopping/starting services to get it to
disappear sooner?
Thanks,
--
Dan D.Hello,
The inactive connections will be removed from SQL Server based on the
application time out setup in appllication layer. Sleeping status doesnt
mean that status is orphan
connection, because most of the time if the process wait for a user Input
or waiting for a lock will be in sleeping mode. It can go for Running
status any time.
Take a look into the below URL:-
http://support.microsoft.com/kb/Q137983
Thanks
Hari
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.|||The connections are held until the application closes them. Many
applications use connection pooling so that closed connections are pooled
for reuse. These will disappear after a short period, IIRC 30-60 seconds.
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.|||These connections are persisting longer than that. Maybe the application has
changed the timeout. Thanks.
--
Dan D.
"Dan Guzman" wrote:

> The connections are held until the application closes them. Many
> applications use connection pooling so that closed connections are pooled
> for reuse. These will disappear after a short period, IIRC 30-60 seconds.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
>|||Interesting article. Thanks.
--
Dan D.
"Hari Prasad" wrote:

> Hello,
> The inactive connections will be removed from SQL Server based on the
> application time out setup in appllication layer. Sleeping status doesnt
> mean that status is orphan
> connection, because most of the time if the process wait for a user Input
> or waiting for a lock will be in sleeping mode. It can go for Running
> status any time.
> Take a look into the below URL:-
> http://support.microsoft.com/kb/Q137983
> Thanks
> Hari
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
>
>

How investigate type of connection to DB( MS SQL or Oracle) during execution of a packet?

How investigate type of a connection to DB( MS SQL or Oracle) during execution of a packet?

In the time of executon of packet I must determine type of connection? What do good practices exists?

Thanks In Advance.

I don't understand the question. The way I read it is counter-intuitive for the way SSIS works. SSIS needs to know upfront which connection to use.|||

Yes, you are right. SSIS needs to know upfront which connection to use IN DESIGN TIME.

I need provide ETL operations for MS SQL and ORACLE databases, but I can't to design two similar packages for Oracle and MS SQL.

Therefore I want:

After deployment into another server I can change type of connection.

For example, I have two databases in ORACLE 9i and MS SQL 2005. Every of these databases has table X for same structure ( field1 int, field2 varchar(X) ). I need to load data from table X.

During design time:

1) In SSIS package I created connection to MS SQL server.

2) I loaded data from DB for some purpose.

After deployment:

I can make a change in connection string in Execute package Utility. For instance, switch connection from MS SQL to Oracle.

During runtime:

I need to know which type of a server this connection to be connected (MS SQL or Oracle). I need it to form a SQL-request in a Task script for SQL-execute script.

|||Yes, you are right. SSIS needs to know upfront which connection to use IN DESIGN TIME.

I need provide ETL operations for MS SQL and ORACLE databases, but I can't to design two similar packages for Oracle and MS SQL.

Therefore I want:

After deployment into another server I can change type of connection.

For example, I have two databases in ORACLE 9i and MS SQL 2005. Every of these databases has table X for same structure ( field1 int, field2 varchar(X) ). I need to load data from table X.

During design time:

1) In SSIS package I created connection to MS SQL server.

2) I loaded data from DB for some purpose.

After deployment:

I can make a change in connection string in Execute package Utility. For instance, switch connection from MS SQL to Oracle.

During runtime:

I need to know which type of a server this connection to be connected (MS SQL or Oracle). I need it to form a SQL-request in a Task script for SQL-execute script.

|||Since the connection string is run-time dynamic , look at the connection string at runtime. In particular, you can use the class OleDbConnectionStringBuilder inside a script task.

To that point, you can get the provider, the data source, and all the other key value pairs as properties (or method calls) against the OleDbConnectionStringBuilder. The provider property will give you the conditionals you're looking for (see http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbconnectionstringbuilder.aspx ) for the properties on this object.

Also, if you're passing in the connection string as a variable, you don't need a script task, you can just parse out the provider using an SSIS expression.

how initialize a connection string in .Net

i am using a control that i downloaded from the control gallery It has a line for a connection string.

which i put on in there:

data source=server;initial catalog=database;user id=blahblah;password=557896

and i get an error:

Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[InvalidOperationException: The ConnectionString property has not been initialized.]
 System.Data.SqlClient.SqlConnection.Open() +433
 Microsoft.Vote.VoteButtonClick(Object sender, EventArgs e) +289
 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
 System.Web.UI.Page.ProcessRequestMain() +1277

How would i initialize the connection string.

any help would be appreciated

aluckeHi,
normally we would have initialized the connection by doing this

dim conn as new sqlconnection("data source=server;initial catalog=database;user id=blahblah;password=557896")

if you still experience error can you print out your codes too?

How I use OpenRowSet with Truested Connection?

Hi,
How I use OpenRowSet with Truested Connection?
SELECT *
FROM OpenRowSet('SQLOLEDB.1', '{SQL Server};SERVER=name', 'select a=1')
Thanks,
Jefferson ValimJefferson,
Here's an example that accesses the local server. Hopefully you
can adapt it for your needs.
select *
from OpenRowset(
'SQLOLEDB.1',
'Trusted_Connection=Yes;Database=Northwi
nd;Integrated
Security=SSPI;Data Source =(local)',
'select 1 as a')
Jefferson Valim wrote:

>Hi,
>How I use OpenRowSet with Truested Connection?
>SELECT *
> FROM OpenRowSet('SQLOLEDB.1', '{SQL Server};SERVER=name', 'select a=1')
>Thanks,
>
>Jefferson Valim
>
>|||Hi
And make sure that Security account delegation is available on the client
and sending server.
http://msdn.microsoft.com/library/d...>
ity_2gmm.asp
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/
"Steve Kass" <skass@.drew.edu> wrote in message
news:ezo0X1wOFHA.904@.tk2msftngp13.phx.gbl...
> Jefferson,
> Here's an example that accesses the local server. Hopefully you
> can adapt it for your needs.
>
> select *
> from OpenRowset(
> 'SQLOLEDB.1',
> 'Trusted_Connection=Yes;Database=Northwi
nd;Integrated
> Security=SSPI;Data Source =(local)',
> 'select 1 as a')
> Jefferson Valim wrote:
>