Priority Application from Spanish Forum | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Priority Application from Spanish Forum

There is two application on same server (not possible two servers by now). It is possible to asign more SQL resources to one of them?. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
WHat does it mean to assign more SQL resources?
What are the issues right now with the application(s)? What are values set for min. & max memory?
How about max worker thread value?
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Applications runs at same time during the day (not all day), one is critical and the original poste said if it possible, to assign more resources ( processor, memory,etc) to critical application.
I sed him, no way, but I would like to be shure.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
In terms of resources means, memory or CPU you can add to the server if any performance degradation in the current situation. Thread pooling helps optimize performance when large numbers of clients are connected to the server. Usually, a separate operating system thread is created for each client connection to consume fewer system resources. However, with hundreds of connections to the server, using a thread-per-connection can consume large amounts of system resources. Using Other than that there is no option to assign dedicated resource to the application from SQL. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Thanks, Satya. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
]]>