The data set may be entirely in memory for both boxes, so I'm not surprised. The boost on the server is when there are lots of people using it, not...

I think there is a resource kit utility to do this, but a quick search on Technet doesn't find it.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Personally I like working with thin clients and a web browser, but then again, that is for simple apps and requires a different mindset. Try to deliver minimal information per...

Can you tell which parts are producing the deadlock? I'd run the proc with a profile running and include the SQL Stmt adn the deadlock events and try to track...

Or the server isn't listening for sockets (check the server network utility).

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Scare me too.

The restore from a network share is the same as another restore, use the UNC path, be sure the SQLAgent has rights to read from the share.

Steve...

ttp://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q263/5/56.asp&NoWebContent=1

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Is this everytime you run a full backup? How are you doing this (EM, code?)

could you have multiple backup jobs scheduled?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

If he has the password and rights in MSDB he should be able to update it.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

If you are trying to "share" the database file between servers, you cannot do this. A server holds the locks on the file and it cannot be shared, even in...

David is right, there isn't a real "Load balancing" solution. The best you could do, and I've done it, is to setup a second server with "read only" data and...

OLAP tends to be larger data sets since it precaclulates values for the cubes. This depends on how you define the cube and how much data in your warehouse is...

I've read about it, basically a "blade" server living in an AS/400 box. Separate NIC, disk, etc. Haven't worked with it, but the cost of the card is probably not...

The disk counters can be a little misleading. Read this http://www.oreillynet.com/lpt/a/1503.

Not sure if it's your issue, but it's interesting. You could have a large Q with low transfer if the...

I'd like to share a beer as well. In fact, be happy to buy one for anyone that's lucky enough to come to PASS.

Especially Antares, you need one