I take this back

I was wrong about changing the User Connections.

SQL Server manages this dynamically.

Antares

After reviewing our app code we are rewriting the code which opens extra connections.

from our developers:

in some cases there is no global oject declared to be used throughout the...

Good point thank you

1) Create a stored proc that lives on the remote server. You'll avoid the RPC call that way.

and call it like this Exec servername.databasename.dbo.procname

2) Index join and where clause fields.

Thanks for all your replies.

Simon the antivirus software excludes mdf and ldf file types.

While reviewing our application code we found some horiffic code which raised a lot of red flags.

1....

SQLGuru hehehe i'm against it 100%.

But our parent company's other magazine sites in other countries are using it and they are very convincing in the board room.

Thank you Steve.

We are looking into every possibility here but as far as upgrading and investing in hardware that will never happen since we are moving into LAMP architecture.

Thank you Noel.

I changed max number of concurrent connections parameter to 65534.

Also using the perf mon i see concurrent connections value changing.

how can i check if the webserver connection pool...

Thanks for all your replies.

There is a fashion show in NYC all this week so yesterday night we hit 1.6 million connections in one hour. of course we had to restart...

It's mostly reads as far as disk I/O goes.

Our 12 webservers use load balancing with fiber connections 2Gbit nic cards in between.

2 seaprate CISCO swtiches and 2 separate T3 lines are...

I changed memory per query.

I did run sql profiler and got many queries.

Going over each one and optimizing them as we speak. There are 100's of queries so it will take...

You can use a table hint with (nolock)

Example: select col1,col2 from table1 with (nolock)

Search books online for more table hints.

not right now.

we are moving towards LAMP in the near future.

MarkusB

SELECT * FROM :: fn_trace_getinfo(default)

This query did not return anything.

It's was weird because i still saw the blackbox.trc and blackbox_1.trc files in datafiles folder and they were being cycled.

I did run this...

Thanks Lori

I've got 5 packages deployed to MSDB of a named instance.

I was able to delete packages from a named instance using

sp_dts_deletepackage

There is also a way to connect...