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