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 Thursday, June 6, 2013 5:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 6, 2013 5:36 AM
Points: 3, Visits: 10
Top tips on reducing CPU load
- Indexing really helps
- Check your SQL queries are efficient (do you need all the data, are the joins optimal)
- Moving queries in stored procs used to help
- Are you doing too many queries and then combining them in a web page script when maybe one query would do
- If it is many reads to one write then maybe consider doing a bit more calculation before saving the data if that is possible. (eg rather than writing a date and then always querying the day of the year, save the day of the year)

Hope this helps...


Matt Jones
IT Support Analyst
ITS | [http://www.theitsolution.co.uk/london-it-support-computer-repair/it-support-london.html]IT Support London[/url] | IT Support Chelsea
Post #1460624
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse