[dba-SQLServer] Which machine does the work?

JWColby jwcolby at colbyconsulting.com
Thu Aug 31 07:48:46 CDT 2006


The reason I ask is to understand what resources I am tying up where and
what tasks it makes sense to do where.  

I am in the process of building an index on a field in a table on MachineA.
I did so from an instance of EM on MachineB.  MachineB shows virtually no
CPU Usage, but MachineA shows an average of around 10-12% CPU usage.  

MachineB does show some light network traffic but it is very light, perhaps
5 packets per second both transmitted and received.  I have a 1 gbit switch
that the machines talk to each over and when I look at network traffic in
Task Manager on MachineB, the traffic is so light that it is literally a
flat line at the very bottom of the graph.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mike &
Doris Manning
Sent: Thursday, August 31, 2006 8:23 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Which machine does the work?

Machine B is doing the work.  To truly understand everything that is
happening inside your SQL Server installation, you need to invest in
software that allows you to read the log files so you can follow the
transactions.

Doris Manning
mikedorism at verizon.net

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Thursday, August 31, 2006 7:54 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Which machine does the work?

I have two machines, both running SQL Server instances.  MachineA has
registered the database on MachineA and the database on MachineB.  MachineB
has done likewise.   MachineA holds a database with a table to which I want
to add an index.  If I open EM on MachineB, select the database on MachineA,
open a table in design view and "add an index", where is the work performed?
Does MachineB actually do anything?  Or does MachineB simply send a command
to the SQL Server instance on MachineA telling it to add the index and all
of the work is performed on MachineA?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list