I have a server with the following config:
Intel P4 Processor
On it I have running a rather large MS SQL DB. For some reason I cannot execute two queries at the sametime. Which for me seems odd!
For example. I am using linked servers to update a table called T_Products. The bottle neck in this operation is the bandwidth between the two linked servers. Therefore CPU is not maxed out, plenty of memory, plenty of I/O. However if I wish to execute another write operation on another table..... it does not allow it - well... it times out.