async_network_IO

I have a process that runs that keeps getting a wait type of async_network_IO
and I was hoping somebody on the board might be able to help out.
I am running SQL2005 on a box with 4 dual core procs, 16GB or RAM, a RAID 5
data partition striped across 8 high-speed drives and 2 disks mirrored for
the system and logs (logs are on a separate logical partition)
I have a job that calls a local executable that essentially summarizes from
one table and inserts/updates another. This is the one that starts a process
that gets the async_network_IO wait type error. I changed the connection
string for the executable to use “Localhost” rather than the DNS name
(thinking that it might have to ask the DNS server what it’s name is) but the
process will still get the same error.
I’m confused why it would be getting this error when nothing should be
traversing the network? Has anybody seen something similar and if so how
were you able to solve the issue?
Thanks,
-Eric
The fact you see some wait type doesn't mean that you necessarily have a
problem with the resource of that wait type. You may want to take a closer
look at two things. First, find whether the wait for that resource type is
significant in terms of absolute numbers and in terms of percentage among all
the resource wait types. Second, try to correlate the waitstats with perfmon
counter values. It's possible that you may have some waits, but things are
not being piled up on disk I/Os, network I/Os, cpu, or memory, etc. Then, you
are probably okay.
Linchi
"ep" wrote:

> I have a process that runs that keeps getting a wait type of async_network_IO
> and I was hoping somebody on the board might be able to help out.
> I am running SQL2005 on a box with 4 dual core procs, 16GB or RAM, a RAID 5
> data partition striped across 8 high-speed drives and 2 disks mirrored for
> the system and logs (logs are on a separate logical partition)
> I have a job that calls a local executable that essentially summarizes from
> one table and inserts/updates another. This is the one that starts a process
> that gets the async_network_IO wait type error. I changed the connection
> string for the executable to use “Localhost” rather than the DNS name
> (thinking that it might have to ask the DNS server what it’s name is) but the
> process will still get the same error.
> I’m confused why it would be getting this error when nothing should be
> traversing the network? Has anybody seen something similar and if so how
> were you able to solve the issue?
> Thanks,
> -Eric
>

async_network_IO

I have a process that runs that keeps getting a wait type of async_network_IO
and I was hoping somebody on the board might be able to help out.
I am running SQL2005 on a box with 4 dual core procs, 16GB or RAM, a RAID 5
data partition striped across 8 high-speed drives and 2 disks mirrored for
the system and logs (logs are on a separate logical partition)
I have a job that calls a local executable that essentially summarizes from
one table and inserts/updates another. This is the one that starts a process
that gets the async_network_IO wait type error. I changed the connection
string for the executable to use â'Localhostâ' rather than the DNS name
(thinking that it might have to ask the DNS server what itâ's name is) but the
process will still get the same error.
Iâ'm confused why it would be getting this error when nothing should be
traversing the network? Has anybody seen something similar and if so how
were you able to solve the issue?
Thanks,
-EricThe fact you see some wait type doesn't mean that you necessarily have a
problem with the resource of that wait type. You may want to take a closer
look at two things. First, find whether the wait for that resource type is
significant in terms of absolute numbers and in terms of percentage among all
the resource wait types. Second, try to correlate the waitstats with perfmon
counter values. It's possible that you may have some waits, but things are
not being piled up on disk I/Os, network I/Os, cpu, or memory, etc. Then, you
are probably okay.
Linchi
"ep" wrote:
> I have a process that runs that keeps getting a wait type of async_network_IO
> and I was hoping somebody on the board might be able to help out.
> I am running SQL2005 on a box with 4 dual core procs, 16GB or RAM, a RAID 5
> data partition striped across 8 high-speed drives and 2 disks mirrored for
> the system and logs (logs are on a separate logical partition)
> I have a job that calls a local executable that essentially summarizes from
> one table and inserts/updates another. This is the one that starts a process
> that gets the async_network_IO wait type error. I changed the connection
> string for the executable to use â'Localhostâ' rather than the DNS name
> (thinking that it might have to ask the DNS server what itâ's name is) but the
> process will still get the same error.
> Iâ'm confused why it would be getting this error when nothing should be
> traversing the network? Has anybody seen something similar and if so how
> were you able to solve the issue?
> Thanks,
> -Eric
>sql

async_network_IO

I have a process that runs that keeps getting a wait type of async_network_I
O
and I was hoping somebody on the board might be able to help out.
I am running SQL2005 on a box with 4 dual core procs, 16GB or RAM, a RAID 5
data partition striped across 8 high-speed drives and 2 disks mirrored for
the system and logs (logs are on a separate logical partition)
I have a job that calls a local executable that essentially summarizes from
one table and inserts/updates another. This is the one that starts a proces
s
that gets the async_network_IO wait type error. I changed the connection
string for the executable to use “Localhost” rather than the DNS name
(thinking that it might have to ask the DNS server what it’s name is) but
the
process will still get the same error.
I’m confused why it would be getting this error when nothing should be
traversing the network? Has anybody seen something similar and if so how
were you able to solve the issue?
Thanks,
-EricThe fact you see some wait type doesn't mean that you necessarily have a
problem with the resource of that wait type. You may want to take a closer
look at two things. First, find whether the wait for that resource type is
significant in terms of absolute numbers and in terms of percentage among al
l
the resource wait types. Second, try to correlate the waitstats with perfmon
counter values. It's possible that you may have some waits, but things are
not being piled up on disk I/Os, network I/Os, cpu, or memory, etc. Then, yo
u
are probably okay.
Linchi
"ep" wrote:

> I have a process that runs that keeps getting a wait type of async_network
_IO
> and I was hoping somebody on the board might be able to help out.
> I am running SQL2005 on a box with 4 dual core procs, 16GB or RAM, a RAID
5
> data partition striped across 8 high-speed drives and 2 disks mirrored for
> the system and logs (logs are on a separate logical partition)
> I have a job that calls a local executable that essentially summarizes fr
om
> one table and inserts/updates another. This is the one that starts a proc
ess
> that gets the async_network_IO wait type error. I changed the connection
> string for the executable to use “Localhost” rather than the DNS name
> (thinking that it might have to ask the DNS server what it’s name is) bu
t the
> process will still get the same error.
> I’m confused why it would be getting this error when nothing should be
> traversing the network? Has anybody seen something similar and if so how
> were you able to solve the issue?
> Thanks,
> -Eric
>

Assigning database level db_owner permission to a SQL Server Login

Hi friends,
I was hoping that somebody out there would be able to help me out
with this one. I am trying to assign a database level db_owner role
permission to a SQL server level login that I have created. I can
easily do this from enterpise manager but I need to be able to script
this process.
The way I do this from enterprise manager in SQL server 2000 is by
going inside the SECURITY FOLDER in the SQL server, then inside
SECURITY I click on LOGINS and within LOGINS I double click on the
login that I created. I get the SQL Server Login Properties which
contains three tabs - GENERAL, SERVER ROLES and DATABASE ACCESS. I
click on the DATABASE ACCESS tab and then select the appropriate
database and then check the db_owner role in the "Permit in Database
Role" window for the selected database.
I need to be able to do this via a script. Any help would be greatly
appreciated.
Thanks!!!(deepchopra1981@.gmail.com) writes:
> I was hoping that somebody out there would be able to help me out
> with this one. I am trying to assign a database level db_owner role
> permission to a SQL server level login that I have created. I can
> easily do this from enterpise manager but I need to be able to script
> this process.
> The way I do this from enterprise manager in SQL server 2000 is by
> going inside the SECURITY FOLDER in the SQL server, then inside
> SECURITY I click on LOGINS and within LOGINS I double click on the
> login that I created. I get the SQL Server Login Properties which
> contains three tabs - GENERAL, SERVER ROLES and DATABASE ACCESS. I
> click on the DATABASE ACCESS tab and then select the appropriate
> database and then check the db_owner role in the "Permit in Database
> Role" window for the selected database.
> I need to be able to do this via a script. Any help would be greatly
> appreciated.
Why not simply use Profiler to spy on Enterprise Manager?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Apr 21, 1:30 pm, Erland Sommarskog <esq...@.sommarskog.se> wrote:
> (deepchopra1...@.gmail.com) writes:
> Why not simply use Profiler to spy on Enterprise Manager?
> --
> Erland Sommarskog,SQLServerMVP, esq...@.sommarskog.se
> Books Online forSQLServer2005 athttp://www.microsoft.com/technet/prodtechn
ol/sql/2005/downloads/books...
> Books Online forSQLServer2000 athttp://www.microsoft.com/sql/prodinfo/prev
iousversions/books.mspx- Hide quoted text -
> - Show quoted text -
Thats a brilliant idea. It helped. Thanks a ton.

ASP.NET and SQL Server DTS

I want to refill a sql server table through a flat text file(CSV) in ASP.NET just giving the file name. Can somebody help me in this regard that i can do this.

Thanks & Best Regards

Hi saeednawaz,

Check here for solution
http://bhatiaworld.blogspot.com/2005/06/transfering-data-from-text-filesource.html
But this solution is not taking ASP.net into consideration, but it will surely help u.|||

Hello,

Here is an example

' This example assumes the existence of a text file named myFile.txt ' that contains an undetermined number of rows with seven entries ' in each row. Creates a new DataSetDim myDataSet As New DataSet()' Creates a new DataTable and adds it to the Tables collectionDim aTable As New DataTable("Table 1")myDataSet.Tables.Add("Table 1")' Creates and names seven columns and adds them to Table 1Dim Counter As IntegerDim aColumn As DataColumnFor Counter = 0 to 6   aColumn = New DataColumn("Column " & Counter.ToString())   myDataSet.Tables("Table 1").Columns.Add(aColumn)Next' Creates the StreamReader to read the file and a string variable to' hold the output of the StreamReaderDim myReader As New System.IO.StreamReader("C:\myFile.txt")Dim mystring As String' Checks to see if the Reader has reached the end of the streamWhile myReader.Peek <> –1   ' Reads a line of data from the text file   mystring = myReader.ReadLine   ' Uses the String.Split method to create an array of strings that    ' represents each entry in the line. That array is then added as a    ' new DataRow to Table 1   myDataSet.Tables("Table 1").Rows.Add(mystring.Split(","c))End While

In the above example, new dataset will be created with one table that contains the
data of the myfile.txt

If you want to just fill a table then iterate throught myfile.txt, split values
and fill rows.

HTH

regards

ASP.NET 1.1 & Authz

Hi,
At the begining of SQL Reporting Services Installation, windows let me know
that it left have ASP.NET 1.1 and Authz installed.
Can somebody tell me please the links to downloads them, as i can´t find
them in the microsoft web.
Regards & Thank youASP.NET 1.1 Redistributable Package can be found here:
http://www.microsoft.com/downloads/details.aspx?familyid=262d25e3-f589-4842-8157-034d1e7cf3a3&displaylang=en
Regards
Kevin Weir
"Claudio" wrote:
> Hi,
> At the begining of SQL Reporting Services Installation, windows let me know
> that it left have ASP.NET 1.1 and Authz installed.
> Can somebody tell me please the links to downloads them, as i can´t find
> them in the microsoft web.
> Regards & Thank you
>|||...and i got my Authz.dll from here:
http://www.dll-files.com/dllindex/dll-files.shtml?authz
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4925
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=01afe39f8a3a4e0c83286fceeae170e0
*****************************************|||Hi Kevin,
I have already installed the last Framework version.
I still having the same problem when i try to install SQL Services reporting.
Regards,
Claudio
"Kevin Weir" wrote:
> ASP.NET 1.1 Redistributable Package can be found here:
> http://www.microsoft.com/downloads/details.aspx?familyid=262d25e3-f589-4842-8157-034d1e7cf3a3&displaylang=en
> Regards
> Kevin Weir
>
> "Claudio" wrote:
> > Hi,
> > At the begining of SQL Reporting Services Installation, windows let me know
> > that it left have ASP.NET 1.1 and Authz installed.
> > Can somebody tell me please the links to downloads them, as i can´t find
> > them in the microsoft web.
> >
> > Regards & Thank you
> >
> >|||Jared,
Before your advise i already downloaded & installed the Authz from
www.dll-files
and getting the same message when i tried to install SQL Server Reporting.
Regards,
Claudio
"Jared Smith via SQLMonster.com" wrote:
> ...and i got my Authz.dll from here:
> http://www.dll-files.com/dllindex/dll-files.shtml?authz
> *****************************************
> * A copy of the whole thread can be found at:
> * http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4925
> *
> * Report spam or abuse by clicking the following URL:
> * http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=01afe39f8a3a4e0c83286fceeae170e0
> *****************************************
>|||Hi Claudio,
Claudio wrote:
> At the begining of SQL Reporting Services Installation, windows let
> me know that it left have ASP.NET 1.1 and Authz installed.
> Can somebody tell me please the links to downloads them, as i can´t
> find them in the microsoft web.
If you are running Windows 2000 Server, make sure you have the latest SP
installed. If you do have the latest SP installed, you should reapply it
(and reapply any patches since that SP). Once you (re)apply the SP, authz
should be available.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Hi there,
Where did you put the authz.dll file? You need to copy it across to the C:\WINDOWS\system32 folder...
If this doesn;t work, I am out of ideas...
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4925
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=be5885cc4f204998adc0cdc65f958d09
*****************************************|||Hi Jake,
I am running Windows 2000 profesional, with SQL Developer and SQL Service
pack 3a, it´s the same configuration that i had in my old laptop that worked
ok.
I will try installing patches again and see.
Regards & Thank you
Claudio
"Jake Marx" wrote:
> Hi Claudio,
> Claudio wrote:
> > At the begining of SQL Reporting Services Installation, windows let
> > me know that it left have ASP.NET 1.1 and Authz installed.
> > Can somebody tell me please the links to downloads them, as i can´t
> > find them in the microsoft web.
> If you are running Windows 2000 Server, make sure you have the latest SP
> installed. If you do have the latest SP installed, you should reapply it
> (and reapply any patches since that SP). Once you (re)apply the SP, authz
> should be available.
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>|||Claudio I believe you need to have the latest Win 2000 service pack installed
as well.
"Claudio" wrote:
> Hi Jake,
> I am running Windows 2000 profesional, with SQL Developer and SQL Service
> pack 3a, it´s the same configuration that i had in my old laptop that worked
> ok.
> I will try installing patches again and see.
> Regards & Thank you
> Claudio
> "Jake Marx" wrote:
> > Hi Claudio,
> >
> > Claudio wrote:
> > > At the begining of SQL Reporting Services Installation, windows let
> > > me know that it left have ASP.NET 1.1 and Authz installed.
> > > Can somebody tell me please the links to downloads them, as i can´t
> > > find them in the microsoft web.
> >
> > If you are running Windows 2000 Server, make sure you have the latest SP
> > installed. If you do have the latest SP installed, you should reapply it
> > (and reapply any patches since that SP). Once you (re)apply the SP, authz
> > should be available.
> >
> > --
> > Regards,
> >
> > Jake Marx
> > MS MVP - Excel
> > www.longhead.com
> >
> > [please keep replies in the newsgroup - email address unmonitored]
> >
> >|||Kevin,
Even that i have installed W2K SP4 i will reinstall again, let you know.
Regards
Claudio
"Kevin Weir" wrote:
> Claudio I believe you need to have the latest Win 2000 service pack installed
> as well.
>
> "Claudio" wrote:
> > Hi Jake,
> > I am running Windows 2000 profesional, with SQL Developer and SQL Service
> > pack 3a, it´s the same configuration that i had in my old laptop that worked
> > ok.
> >
> > I will try installing patches again and see.
> >
> > Regards & Thank you
> >
> > Claudio
> >
> > "Jake Marx" wrote:
> >
> > > Hi Claudio,
> > >
> > > Claudio wrote:
> > > > At the begining of SQL Reporting Services Installation, windows let
> > > > me know that it left have ASP.NET 1.1 and Authz installed.
> > > > Can somebody tell me please the links to downloads them, as i can´t
> > > > find them in the microsoft web.
> > >
> > > If you are running Windows 2000 Server, make sure you have the latest SP
> > > installed. If you do have the latest SP installed, you should reapply it
> > > (and reapply any patches since that SP). Once you (re)apply the SP, authz
> > > should be available.
> > >
> > > --
> > > Regards,
> > >
> > > Jake Marx
> > > MS MVP - Excel
> > > www.longhead.com
> > >
> > > [please keep replies in the newsgroup - email address unmonitored]
> > >
> > >|||Claudio wrote:
>> Claudio I believe you need to have the latest Win 2000 service pack
>> installed as well.
> Even that i have installed W2K SP4 i will reinstall again, let you
> know.
Yes. I ran into this on one server that already had SP4 installed.
Refreshing that SP and reinstalling hotfixes/patches did the trick.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]]