Are you looking for this http://msdn2.microsoft.com/en-us/library/aa337525.aspx or http://www.sqlusa.com/articles/tablepinning/ If you are looking at Max Concurrent Connection, refer book online for Maximum Capacity Specification