Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SQL Server 2008 R2 is Sending too much Data through the network Expand / Collapse
Author
Message
Posted Wednesday, June 5, 2013 12:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 5, 2013 5:02 AM
Points: 5, Visits: 13
I am using SQL Server 2008 R2 on Windows Server 2008 R2 machine and the SQL is sending too much data from the network causing the website to perform slow. Please suggest what to do.

Post #1460048
Posted Wednesday, June 5, 2013 1:01 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 40,208, Visits: 36,617
SQL will send the application the data that it requested, it won't send random stuff without some app querying it. If the application is requesting too much data, tune the queries and/or change the application design


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1460049
Posted Wednesday, June 5, 2013 1:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:21 AM
Points: 1,380, Visits: 2,698
SQL Geek (6/5/2013)
I am using SQL Server 2008 R2 on Windows Server 2008 R2 machine and the SQL is sending too much data from the network causing the website to perform slow. Please suggest what to do.



How did you come to that conclusion? Are you noticing network_io waits ?



Regards
Post #1460052
Posted Wednesday, June 5, 2013 1:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 6:41 AM
Points: 25, Visits: 167
Run a trace to see what is causing the "traffic"? Analyse the results or post an extract for assistance
Post #1460056
Posted Wednesday, June 5, 2013 1:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 5, 2013 5:02 AM
Points: 5, Visits: 13
Yes, You are right but its happening since last 3-4 days only, everything before that was working absolutely fine. We have not changed the queries or anything. Its now utilizing the CPU to nearly 90-100%. I think I have missed some SQL Patch.
Post #1460058
Posted Wednesday, June 5, 2013 1:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 5, 2013 5:02 AM
Points: 5, Visits: 13
Hi Grasshopper, Please instruct me how to do this.
Post #1460059
Posted Wednesday, June 5, 2013 1:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 5, 2013 5:02 AM
Points: 5, Visits: 13
Hi SQLSACT, There is no wait only the CPu utilization is 90-100%.
Post #1460061
Posted Wednesday, June 5, 2013 1:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 6:41 AM
Points: 25, Visits: 167
Open profiler,
File, new trace.
Connect to your sql server.
Use the template -> select Tuning
select save to file -> choose a location with sufficient space

select -> enable trace stop time 10 minute of data should be sufficient move it up 30 minutes if you need. The more data you gather the more needs to be analysed.

After you have collected the trace data. Open the trace file in the database tuning advisor
on the general tab select your database and trace file. Start anaylsis.
The queries that are affecting the system will be show in the results as well as suggestions of possible index optimisation

Hope this help
Post #1460063
Posted Wednesday, June 5, 2013 1:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:21 AM
Points: 1,380, Visits: 2,698
Have a look at these articles

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/
Post #1460065
Posted Wednesday, June 5, 2013 2:10 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 40,208, Visits: 36,617
SQL Geek (6/5/2013)
Hi SQLSACT, There is no wait only the CPu utilization is 90-100%.


CPU usage at 100% in no way indicates or suggests that there's too much network traffic.

In contrast, it's an indication that one or more queries are performing inadequately, either due to changes to the query, the tables or the data.

Identify what queries are using the CPU, tune them to work more efficiently
Chapter 3: https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1460070
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse