SQL Server Performance Tuning
In Performance Monitor, there is an object called Network Interface. What does it mean and under what circumstances would you use it?
We have recently added a second processor to our SQL Server box. How can I configure it to take advantage of the new processor?
Is there any benefit for me in turning on the "lightweight pooling" SQL Server configuration option?
Is it better to have one large server running multiple databases, or several smaller servers running one database each?