Can't say I've limited the number of people visiting my site but you can easily limit the number of connections to your database by specifying it in either your connection string or configuring it in SQL Server. For the number of people accessing your site, you may be able to do some work on the network side of things to limit access.