I love reading, and used to read 50+ books a year. Now it's higher with the Kindle apps distributed across phones, PCs, and iPads. I can read almost anywhere that...

We had a deployment early am today, UK time, so there was some downtime there. Should have pointed to a maintenance page on this same server, so no DNS flushing...

Yikes, lots of thread activity since I disappeared Fri am.

Being unwired is nice 😉

You have to dig in further. What else is happening at that time? If you have a window, then focus there. What does the application do? Can you run that...

One last point, make sure you have free space in the files. You should not be growing SQL Server data files every time you add data. You want enough space...

That should work fine. You also could have the ASP kick off a job when it's done, and have that job run the T-SQL, or even move this to SSIS...

Run a network trace, see what tried to connect on 1434, or run a netstat from a command prompt. that should tell you what socket is open.

There is no real easy way. You will have to start looking at what bottlenecks are occurring. Is the server overloaded? Too much CPU/Memory/disk usage? Does the code run...

Sorry, a scheduling glitch in the Matrix. If you see a black cat, run.

Are you using SQLCmd or Management Studio? You don't want to use SSMS as it takes multiple connections

More good feedback. I somewhat aimed this at accidental DBAs, but I think I've moved into development a bit and probably need to split this off to two sessions.

As Gail says, that's the maximum number of connections, period.

I would doubt that you would have 100,000 users all connecting at the same time to the same database. If so,...

Short answer is add more hardware.

You haven't given anywhere near enough information to take a guess, and this isn't something that will be answered in a forum.

Are there bottlenecks?...

Books Online is a good spot to start learning the terms. There's a whole section there. Once you have that, there is some good info here: http://www.sqlshare.com/Search.aspx?terms=clustering

This is roughly what to do. There is some overhead, but once you get to millions of rows, it doesn't matter.

Don't forget that the clustering key is in all...