Named pipes vs TCP/IP and NETWORKIO wait type

I am experiencing a problem whereby a 3rd party application is performing data transfers between tables in a database and they are taking enormous amounts of time.
I have no way of knowing what it is actually doing but when I examine the current activity, the RUNNABLE process shows NETWORKIO in the Wait Type column. What is this as I have not been able to find anything in BOL.
Related to this, what is the faster way of connection: named pipes or TCP/IP ? Both the client and the server have both enabled but the application is using TCP/IP to connect. Would named pipes be faster ?
Regards,
Peter Apostolakopoulos.
Check this out: http://sqldev.net/misc/WaitTypes.htm
Are both these tables in the same DB? What command is it using?
Andrew J. Kelly SQL MVP
"Peter Apostolakopoulos" <apostolp@.britannic.co.uk> wrote in message
news:BDFFD198-0B85-44EE-9CC3-55863CD7F980@.microsoft.com...
> I am experiencing a problem whereby a 3rd party application is performing
data transfers between tables in a database and they are taking enormous
amounts of time.
> I have no way of knowing what it is actually doing but when I examine the
current activity, the RUNNABLE process shows NETWORKIO in the Wait Type
column. What is this as I have not been able to find anything in BOL.
> Related to this, what is the faster way of connection: named pipes or
TCP/IP ? Both the client and the server have both enabled but the
application is using TCP/IP to connect. Would named pipes be faster ?
> Regards,
> Peter Apostolakopoulos.
|||Andrew,
Many thanks for the info. It is very useful. I am still having problems but I am pursuing this with the suppliers as I they have written some custom SQL to do the data migration which is "not the best" !!
Peter Apostolakopoulos
sql

Named pipes vs TCP/IP and NETWORKIO wait type

I am experiencing a problem whereby a 3rd party application is performing da
ta transfers between tables in a database and they are taking enormous amoun
ts of time.
I have no way of knowing what it is actually doing but when I examine the cu
rrent activity, the RUNNABLE process shows NETWORKIO in the Wait Type column
. What is this as I have not been able to find anything in BOL.
Related to this, what is the faster way of connection: named pipes or TCP/IP
? Both the client and the server have both enabled but the application is u
sing TCP/IP to connect. Would named pipes be faster ?
Regards,
Peter Apostolakopoulos.Check this out: http://sqldev.net/misc/WaitTypes.htm
Are both these tables in the same DB? What command is it using?
Andrew J. Kelly SQL MVP
"Peter Apostolakopoulos" <apostolp@.britannic.co.uk> wrote in message
news:BDFFD198-0B85-44EE-9CC3-55863CD7F980@.microsoft.com...
> I am experiencing a problem whereby a 3rd party application is performing
data transfers between tables in a database and they are taking enormous
amounts of time.
> I have no way of knowing what it is actually doing but when I examine the
current activity, the RUNNABLE process shows NETWORKIO in the Wait Type
column. What is this as I have not been able to find anything in BOL.
> Related to this, what is the faster way of connection: named pipes or
TCP/IP ? Both the client and the server have both enabled but the
application is using TCP/IP to connect. Would named pipes be faster ?
> Regards,
> Peter Apostolakopoulos.|||Andrew,
Many thanks for the info. It is very useful. I am still having problems but
I am pursuing this with the suppliers as I they have written some custom SQL
to do the data migration which is "not the best" !!
Peter Apostolakopoulos

Mysterious Stored Procedures

SQL Server 2005 sp1

Maybe you can answer this.

Are the Stored Procedures dt_CheckOutObject and dt_CheckInObject used for some type of built-in source control?

Is source control for SQL Server built-in to the Management Studio, or is it purchased separately?

Thanks!

Frank

These are created when you connect using some Visual Tools of Microsoft, this is the list of procedures which will be created during the process:

dt_addtosourcecontrol
dt_addtosourcecontrol_u
dt_adduserobject
dt_adduserobject_vcs
dt_checkinobject
dt_checkinobject_u
dt_checkoutobject
dt_checkoutobject_u
dt_displayoaerror
dt_displayoaerror_u
dt_droppropertiesbyid
dt_dropuserobjectbyid
dt_generateansiname
dt_getobjwithprop
dt_getobjwithprop_u
dt_getpropertiesbyid
dt_getpropertiesbyid_u
dt_getpropertiesbyid_vcs
dt_getpropertiesbyid_vcs_u
dt_isundersourcecontrol
dt_isundersourcecontrol_u
dt_removefromsourcecontrol
dt_setpropertybyid
dt_setpropertybyid_u
dt_validateloginparams
dt_validateloginparams_u
dt_vcsenabled
dt_verstamp006
dt_verstamp007
dt_whocheckedout
dt_whocheckedout_u
dtproperties

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Good morning, Jens.

Can you tell me if we can drop these sp? For example, say, for a clean distribuition of a database, with table-only content?

Thanks a lot.

Fernando M.

|||Yes, if you need created database diagrams you should leave the dbpoperties.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Mysterious Stored Procedures

SQL Server 2005 sp1

Maybe you can answer this.

Are the Stored Procedures dt_CheckOutObject and dt_CheckInObject used for some type of built-in source control?

Is source control for SQL Server built-in to the Management Studio, or is it purchased separately?

Thanks!

Frank

These are created when you connect using some Visual Tools of Microsoft, this is the list of procedures which will be created during the process:

dt_addtosourcecontrol
dt_addtosourcecontrol_u
dt_adduserobject
dt_adduserobject_vcs
dt_checkinobject
dt_checkinobject_u
dt_checkoutobject
dt_checkoutobject_u
dt_displayoaerror
dt_displayoaerror_u
dt_droppropertiesbyid
dt_dropuserobjectbyid
dt_generateansiname
dt_getobjwithprop
dt_getobjwithprop_u
dt_getpropertiesbyid
dt_getpropertiesbyid_u
dt_getpropertiesbyid_vcs
dt_getpropertiesbyid_vcs_u
dt_isundersourcecontrol
dt_isundersourcecontrol_u
dt_removefromsourcecontrol
dt_setpropertybyid
dt_setpropertybyid_u
dt_validateloginparams
dt_validateloginparams_u
dt_vcsenabled
dt_verstamp006
dt_verstamp007
dt_whocheckedout
dt_whocheckedout_u
dtproperties

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Good morning, Jens.

Can you tell me if we can drop these sp? For example, say, for a clean distribuition of a database, with table-only content?

Thanks a lot.

Fernando M.

|||Yes, if you need created database diagrams you should leave the dbpoperties.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

My Products table

hello,

i have a Products table, and i want to make an image data type to one of his rows (Picture1 for example), i want to know, what is best, to store the picture in the database or store only the direction to the picture?

if i store only the direction, i should take it from some output parameters of the Upload function of ASP and the add it to the Database? can i add it to a special folder for example MySite\UserName\ + file name?

and another thing: let's say i have Promotion - tinyint, to store the promotion value of this product..If i show products using DataList, i could order my products first after Promotion and then after date added? could i use a special CssClass(font weight or other background) for the products witch has the Promotion more than 10 for example?

how can i know the exact date time (yy/mm/dd/hh/mm) ? - it is taked from the Server date?

thank you

Have a look at

http://www.codeproject.com/aspnet/PicManager.asp|||

Hi zuperboy90,

i have a Products table, and i want to make an image data type to one of his rows (Picture1 for example), i want to know, what is best, to store the picture in the database or store only the direction to the picture?

if i store only the direction, i should take it from some output parameters of the Upload function of ASP and the add it to the Database? can i add it to a special folder for example MySite\UserName\ + file name?

Well, it depends. If your image file size is very large on everage, I would suggest you using sql database to store the link and using a file server to store the actual image file. Actually it's not too dificult to impliment. Using asp.net update control to store the image file to a specific folder, and pass the path(with the file name) to your backend database.

If your image file is not a big one,then just create a new field named "image" with type "binary(SIZE)", and fill this field using a stream writer. This is a very conveninet way if you only want to store some icon/thumbnail pictures.

There are lots of sample articles on this, just type "picture gallery asp.net" into google and you will find millions of resources.

Hope my suggestion helps

|||

for a wile i store in my database only the link to the pictures (they are very many, and hight resolution), and i think i'll use something like ImageUrl = <%# Eval("url") %>, i don't know exacly how it will be, i'll se if it is ok when implementing the code that alowes you to add pictures, and then chose the best way

thank you