SQL Network Perf Issues

Mar 19, 2003

I have a SQL2000 db running a vendor custom app on a Win2000 sp3 server. The front-end is run on Citrix to the client. Can't change the app or the somewhat poor infrastructure of client. users starting to complain about slowness ( we can shadow them and this seems the case). On the SQL box all the standard perf counters look good (buffer cache at 100%, queue length always less than 1, memory and disk look good. The server currently has 2 nics doing load balancing. The network counter bytes/sec averages over 100,000. The network counter output queue length shows an average of 4,294,967,251 (That seems high but in reading on another sql perf site this counter doesn't always work). Any other ideas where I might look. Do these numbers look high?
Thanks

View 1 Replies


ADVERTISEMENT

Perf Mon

Mar 15, 1999

On an installation of sql 6.5, when I go to performance monitor, there are no sql counters. What gives? How can this be fixed,and do I have to reinstall,(wipeout data) to do it?

View 2 Replies View Related

SQL Perf Mon

Nov 9, 1998

The User Defined Counters Object has disappeared from me Performance Monitor.
Any ideas why or how to get it back? Thanks, Mike

View 1 Replies View Related

Perf Monitor

Feb 24, 2004

Is there anyway that you can automate performance monitor from the cmd line. I.e feed it some parameters like server and counters and receive a log file at the end.

Cheers

View 5 Replies View Related

Perf Report Query

Sep 22, 2005

CREATE TABLE [Perf] ([TransId] INTEGER,[FileNo] VARCHAR(80),[TimeInSeconds] INTEGER,[FileSizeMB] INTEGER,[FileName] VARCHAR(255),[StartDate] datetime)Ok!! Here's the Problem. I am working on a perf stats report. FileType is First 9 chars of the field FileName. I need to compare a similar filename from this month to last month or before ordered by file size. Maybe this is a very simple query but currrently my mind refuses to work. Seeking F1.

View 3 Replies View Related

MSDE And Missing Perf Counters

May 15, 2002

The SQL performance couters do not get installed with MSDE. Does anyone know how to install them??

View 2 Replies View Related

Sql 2000 Perf Monitoring Books

Mar 23, 2004

Any recommendations from DBA's on good books for performance monitoring for sql 2000

View 2 Replies View Related

Perf Tuning Question - Gurus Only

Feb 19, 2004

Howdy

I have a server that has the following average readings :

No. CPUs = 1
% CPU = 2
SystemCPU Queue Length = 2 to 4
SQL Server:Buffer ManagerBuffer Cache = 99.85%
RAM in the box = 1 GB
MemoryPages/sec = 1 to 5
SQL memory in use ( using Task Manager ) = 250 MB
Max worker threads = 255
Average number of connection = 60

So...........all indicators are that the CPU is idling, there is way enough RAM but we still have a ( in theory ) a congested CPU as the queue length is over 2 consistantly. Thing is, I need to work out if the CPU isnt working hard as the queue is long, or whether we can put extra databases/load on the box.

As the max worker threads are greater than number of connections ( 60 vs 255 ) we could reduce these as the number of users doesnt seem to alter much. BUT.......would this make much difference as if the 255-60=195 worker threads arent doing anything much, they shouldnt put any load on the server, right?

Any thoughts much appreciated.

Cheers,

SG.

View 13 Replies View Related

High Value For The PagesSec Perf Counter

Feb 26, 2008

Hello All,

I have a 64-bit SQL Server running on 64-bit OS having 12GB of RAM. The Server only hosts our Application database (its a 30 GB database). There are no major process running on it. Despite of this, the Avg Pagessec shows a count of 1500 and
the Avg Page Faultsec shows 22000. Is there any specific reason as to why this is happening? The %idle time of the disk is 87%. Also there is no major load on the server. Do let me know if you need any other input.

Thanks in Advance,
Mitesh

View 2 Replies View Related

Perf On Read Uncommitted Isolation Level

Jul 5, 2005

Are there really any benefit on using Read Uncommitted Isolation Level or having a NOLOCK hints for retrieve queries when the default Isolation level just Read Committed (not using COM+).  I'm confused why the Community Server uses this technique perhaps for perf issues but I couldn't see any reason why...

View 1 Replies View Related

SSIS Perf Tuning - Tables Of 15M+ Rows

Feb 28, 2008

The challenge: I have to extract and convert data between 2 SQL server systems - only 4 tables on the source systems, 8 tables on the target system. Source tables have between 5,000 rows and 16,000,000 rows. For most of the tables (for example Customer, which goes into 4 target tables), there will be 1 row in target tables for each row in the mapped source system table - so my 13.5M customer rows will end up as around 40M rows across the 4 target tables. So far, so good. But - this is a 24x7 online retail web-site, and to get the data across as a clean process, we require the smallest possible duration.

I have progressed on the customer migration, and am testing on a test environment (2xdual core HT processors, 4 GB ram) which was 2.15 million rows. Live environment is likely to be a 4xdual core with 8-16 GB ram.

I am trying to optimize the extract data flow, and have read the SSISperfTuning doc. I am now trying to put that into practice.
I have a row size of approx 340 bytes, so based on that, and my test environment of 2.15 million rows, I work out at around 700 MB ram required to buffer the data. That is a factor of 7 times greater than the max buffer space for a data flow of 100 MB, which it seems, means I should divide the base MaxBufferRows (10000) by 7 to go down to 1400 rows?

I see a LOT of the following messages in my progress, when running with default settings:
[DTS.Pipeline] Information: The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 30 buffers were considered and 30 were locked. Either not enough memory is available to the pipeline because not enough is installed, other processes are using it, or too many buffers are locked.

The design of the data flow at the moment is:


..........................................|--target table 1
SOURCE SP ---- MULTICAST---|--target table 2
..........................................|--target table 3
..........................................|--target table 4

any thoughts on Buffer tweaking, corrections to my assumption and other hints/techniques?


*##* *##* *##* *##*
Chaos, Disorder and Panic ... my work is done here!

View 7 Replies View Related

2005 Perf Much Worse Than 2000... Suggestions Please..

Nov 20, 2006

I have this SP that takes several varchar columns and concatinates them all together then inserts them into a text field. I do this with a cursor which was the quickest way to get it done when it was setup...

However when I moved the process to a 2005 server (on the same physical server) the process drastically slowed down. On 2000 the process took about 7 min to handle all 350k+ rows with the processors hanging around 20-40%... On 2005 it took over 30 min (not sure how long it would take cause I killed the process) and the processors stay above 98%...

I have rewritten the process to use a while loop instead of the cursor (I wanted to do this anyways) and it had no effect. At this rate (about 1 row a second) it will take forever and this process runs everyday.

Any ideas??

Here is the procedure...

declare @srch_field varchar(8000)

declare @row int, @productid varchar(25)

DECLARE @title varchar(150), @actors_keyname varchar(1200), @directors_name varchar(400)

Declare @genres varchar(700), @theme varchar(1500), @type varchar(1500), @studio_desc varchar(100)

DECLARE @media_format varchar(50), @artist_name varchar(100), @dev_name varchar(100)

DECLARE @flags varchar(256), @starring varchar(256), @esrb varchar(100), @esrb_desc varchar(500)

DECLARE @ptrval varbinary(16), @text varchar(max)

declare @productlist table(product_id varchar(25), IDNUM int identity)

insert into @productlist (product_id)

select product_id

from music_load..globalsearch

select @row = @@rowcount

while @row > 0

begin

select @productid = product_id

from @productlist

where idnum = @row

SELECT @title = rtrim(title) ,

@actors_keyname = actors_keyname ,

@directors_name = directors_name,

@genres = genres ,

@theme = theme ,

@type = type ,

@studio_desc = studio_desc,

@media_format = media_format ,

@artist_name = artist_name,

@dev_name = dev_name,

@flags = flags ,

@starring =starring ,

@esrb = esrb ,

@esrb_desc = esrb_desc

FROM globalsearch

where product_id = @productid

Set @srch_field = isnull(@title,'')

if @actors_keyname is not null and @actors_keyname <> 'unknown'

Set @srch_field = @srch_field + ' ~ ' + rtrim(@actors_keyname)

if @directors_name is not null and @directors_name <> 'unknown'

Set @srch_field = @srch_field + ' ~ ' + rtrim(@directors_name)

if @genres is not null

Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@genres, 0,''))))

if @theme is not null

Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@theme, 0,''))))

if @type is not null

Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@type, 0,''))))

if @studio_desc is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@studio_desc)

if @media_format is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@media_format)

if @artist_name is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@artist_name)

if @dev_name is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@dev_name)

if @flags is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@flags)

if @starring is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@starring)

if @esrb is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@esrb)

if @esrb_desc is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@esrb_desc)

update globalsearch

set srch_field = @srch_field

where product_id = @productid

SELECT @ptrval = TEXTPTR(srch_field),

@text = credits

FROM globalsearch

where product_id = @productid

UPDATETEXT globalsearch.srch_field @ptrval NULL NULL @text

SELECT @ptrval = TEXTPTR(srch_field),

@text = track

FROM globalsearch

where product_id = @productid

UPDATETEXT globalsearch.srch_field @ptrval NULL NULL @text

set @row = @row - 1

end



View 5 Replies View Related

Loading Data Warehouse (Perf. Tuning)

Feb 25, 2008



Hi all,

I'm loading my data warehouse using several SCDs. Some of these SCDs need to occur in sequence, while others can be run at the same time. I'm wondering what the best option for me is in terms of performance. Here is what I was considering:

1) Create a single package. Create two sequence containers --- one that will contain SCD loads that occur in sequence; the other sequence container contains SCD loads that occur in parallel.

OR

2) Create a set of packages for each SCD load. Then create a "Master" package that will use "Execute Package Task" components to call these packages.

The othe reason I want to bring up these difference ways to design an DW Load is because the second option is a "cleaner" approach, or a more organizational approach, to the load. The first option can get quite messy and large if you have several SCDs and several sequence containers. However, I'm looking for the fastest performance. Any thoughts?

View 7 Replies View Related

Webinar On High-perf Extracts From Oracle, DB2, Teradata, Etc.

Jul 12, 2006

This webcast from our partner, ETI, may be of interest to readers on the forum - we see questions quite often about high-performance interaction with other databases.

Donald

View 4 Replies View Related

2005 Developer - Perf Monitor Counter Check Failed Message

Nov 11, 2006

Trying to install 2005 Dev edition in xp pro, sp2.

Performance Monitor Counter Check Failed Error.
Had to stop the install twice at the point it verified what components were to be included as
the docs were not going to be installed. Resolved the issue.

Now it won't pass the system config test because the registry is not the way it wants it.
I look up the messages and the only solution is to hack the registry and risk my system.

This is nuts.

Isn't there some way to restart cleanly without hacking registry keys ?

Help.

View 3 Replies View Related

[DBNETLIB][ConnectionRead (recv()).]General Network Error. Check Your Network Documen

Sep 30, 2004

Hello all,

We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.

This site receives the following error as seen in the topic:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_connSpankMSSQL_STRING = "Provider=sqloledb;Data Source=SERVER_IP,1433;Network Library=DBMSSOCN;Initial Catalog=ourmaindb_1;User ID=ourmaindb_1;Password=hotcookies;"
%>

Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.

The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.

Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.

Should have 330 rows if it works right.

View 2 Replies View Related

[DBNETLIB][ConnetionWrite (WrapperWrite()).]General Network Error. Check Your Network

May 19, 2004

Hi
While running a DTS, many times the error message: "[DBNETLIB][ConnetionWrite (WrapperWrite()).]General network error. Check your network documentation." appears.
Does somebody knows why?

I am running the DTS from a computer (not the server where the DTS is stored) and it is connected without any problem when this happens.

Thanks!!
Regards
Lautaro - Argentina.

View 4 Replies View Related

ASP.Net 1.1 With SQL 2005 : General Network Error. Check Your Network Documentation

Oct 4, 2007

Hi Every one,

I am using .Net 1.1 for my web application.

And my database server is SQL Server 2005.

My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,

General Network Error. Check your network documentation


I have also searched many articles and tried following solutions but nothing working

- connectiontimeout = 0, max pool size = 7500/100, pooling = false

- SSL disabling enforce security false as mentioned in microsoft kb article.

And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string)

Can any one please help me to solve this error?

With Regards,

View 3 Replies View Related

General Network Error. Check Your Network Documentation

May 26, 2007

Hi We have a written a error log in Global.asax. which capture below mentioned error in the prodcution server. Same applications is working fine in some locations and some loactions we are getting the error.Any body knows why this error is occurs.Any body knows why this error is occurs. Error Message:General network error. Check your network documentation.Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at datalayer.sqldb.Execute(String ProcedureName, SqlParameter[] Parameters) at lms.User.GetUserDetails(String strUserid)ITs at LMS.Login.w_btn_Login_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

View 2 Replies View Related

General Network Error. Check Your Network Documentation

Oct 4, 2007

 Hi,I am using .Net 1.1 for my web application.And my database server is SQL Server 2005. My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,General Network Error. Check your network documentation  I have also searched many articles  and tried following solutions but nothing working- connectiontimeout = 0, max pool size = 7500/100, pooling = false- SSL disabling enforce security false as mentioned in microsoft kb article. And there's  nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string) Can any one please help me to solve this error? 

View 2 Replies View Related

General Network Error. Check Your Network Documentation

Feb 8, 2004

When I try to update the site setting, I get this Error and I don't know how to fix.

Server Error in '/DotNetNuke' Application.
--------------------------------------------------------------------------------

General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.

Source Error:


Line 281:
Line 282: myConnection.Open()
Line 283: myCommand.ExecuteNonQuery()
Line 284: myConnection.Close()
Line 285: End Sub


Source File: C:DotNetNukeComponentsAdminDB.vb Line: 283

Stack Trace:


[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +721
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
DotNetNuke.AdminDB.UpdatePortalInfo(Int32 PortalId, String PortalName, String PortalAlias, String LogoFile, String FooterText, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, String ExpiryDate, Double HostFee, Double HostSpace, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory) in C:DotNetNukeComponentsAdminDB.vb:283
DotNetNuke.SiteSettings.Update_Click(Object sender, EventArgs e) in C:DotNetNukeadminPortalSiteSettings.ascx.vb:287
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

Please Help!

Thank you,

dlouanis

View 2 Replies View Related

General Network Error. Check Your Network Documentation

Jan 9, 2006

I use sqlclient to connect directly from my mobile 5 pocketpc to a sql server 2005 database on my desktop.

I use a sqldatareader to traverse the results of a query that delivers 2 fields: (1) the filespec, and (2) the image field.

I use a filestream with a binary writer to write the contents of the image data to the pocketpc's storage card.

I have a test table with 10 images, not one more than 4 MB.  I cannot complete a test run prior to receiving the  general network error.

The pocketPC is connected via activesync to the desktop, and I connect to the database with:

Integrated Security=false;
user id=sa
password=admin.

Any help with this strange error would be greatly appreciated.

Wil

View 5 Replies View Related

General Network Error Check Network Documentation

Oct 11, 2006

Hi I get a "General Network Error Check network documentation" error sometimes, but its only while insert or update statements are fired while selects keep working perfectly.

The Error details are as follows:
General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
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:

[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

View 1 Replies View Related

General Network Error. Check Your Network Documentation. Error Number 11

Aug 16, 2005

  Hi,I am getting the following error (When i am trying to update the column thru windows service) Please let me know the solution for the following.The following error is comming only when i set CommandTimeout to infinity (Commandtimeout=0).General network error.  Check your network documentation. Number 11 Procedure ConnectionRead (recv()). Class 20 State 0 Source .Net SqlClient Data Provider Server  Line number 0 Thanks and Best RegardsNagaraju A

View 2 Replies View Related

What Is Client Network And Server Network Alias In SQL Server.

Jul 28, 2007



Hi all,

What is client network and server network alias in SQL server.

when and why we should use that mean what is the requirement of ALIAS in SQL Server.

Thanks

View 5 Replies View Related

Network

Jul 20, 2005

We are developing with SQL 7 Developer Edition and planning to installMSDE with the VB application. We received the following question fromthe IT dept. of our client:"Does your version of SQLServer database work well across a framerelay wide area network?"Should there be any problems regarding speed, etc.?Thanks!Ernie Adsett

View 2 Replies View Related

Network To Web Server

Nov 15, 2006

Hello
I am new to .net and asp.net.  On my local network i have our accounting system using sql 2005 and also a have an access database. We need to get this data to our web site sql 2005 database which is not connected to our network.  Can somebody advise me on which would be the best and most secure way? Should i use Web Services to communicate between the network and the web server  or use some other method like FTP, smtp?
Thanks in advance for any help

View 4 Replies View Related

SQL Network Libraries

May 9, 2007

as far as i know, i can use these types of network libraries:





dbnmpntw - Win32 Named Pipes


dbmssocn - Win32 Winsock TCP/IP


dbmsspxn - Win32 SPX/IPX


dbmsvinn - Win32 Banyan Vines


dbmsrpcn - Win32 Multi-Protocol (Windows RPC)
may be someone knows, where i could find comparision and details of each one, when witch to use?

View 1 Replies View Related

Network Error

Dec 29, 2004

Hi,
Running a stored procedure in query analyser returns data but when running the asp.net page which uses that stored procedure returns an exception which is:
General network error. Check your network documentation

Do you know what the problem could be please?
Thanks

View 3 Replies View Related

Network Libraries

May 15, 2002

I have problems using SQL Profiler from a Windows2000 client PC to an SQL 7 server which is on a Windows NT machine. I can use profiler o.k. from an NT client (using Named Pipes), but can't seem to get it to work on my Windows2000 PC.
I tried changing the Default Network Library on my PC to use TCP/IP, but it still does not work. The server has a default of Named Pipes.
Can I get the server to use either Named Pipes or TCP/IP depending on whether the client communicating is an NT or Windows2000 PC?
Or is this not the problem? Is there a problem with Windows2000 and Named Pipes?

View 5 Replies View Related

Restoring DB From The Network

Apr 4, 2001

Hi,
I am trying to restore SQL7 DB from the Network M/C,here is the Procedure i am following

i have backup file on ABCsqlbackup where ABC is M/c Name on the network

from my Server i mapped ABCsqlbackup to the I drive
then from enterprise magager i tried to restore DB and i gave path as I:xyz.bak
for backup device location where xyz.bak is backup file name.

when i tried to restore like this it is giving error "unable to verify backup file location"
and i checked in SQL server logs i found that message like..
"Unable to open Backup Device I:xyz.bak Failed to open.Operating system error,Unknown user name or bad password"

and that Sqlbackup directory is shared and it has full access to everyone.

Can anybody tell me how to restore from the Network, and where i am doing wrong.

Thanks in Advance
Mark

View 2 Replies View Related

All SQL Servers On The Network???????

Jul 10, 2001

Hi Friend,
Is there any way in SQL Server by which I can locate the names of all the SQL-servers on the network. I was wondering if I can execute some query on Master database to find the above info??? Any clues??

Thanks in advance
Wiz

View 1 Replies View Related

DTS Won&#39;t Work Over Network

May 15, 2000

hello,

i am trying to run a data transformation service from my win 98 machine running the sql7 server client. i keep getting the error 'general network error'

it used to work before but doen't anymore. any ideas?


thanks,
ayan

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved