In a scenario, where 100 users over LAN open data entry application and edit values(in a grid) from 9 AM to 9 PM, wouldn't there be a speed issue, if...

whether required to restart server pc during SQL server non-responsive state?

i.e.. pending memory grants >0 or restart SQL server ? ( or any other method like DBCC FREEPROCCACHE)

Ok thanks, connections were kept open till application was closed to reuse. Connection string is unique for a DB, so will change to close and open logic.

Whether connection pools are...

Okay  Thank You.

If  Execution speed is the only issue, can we move ?

Is it possible to find the query causing problem?

Because error comes randomly(once per week) and too many queries/programs run daily and continuously.

I am using SQL Server 2008 R2  in Windows...

I  am trying to find reason for below error

"There is insufficient system memory in resource pool 'internal' to run this query."

We have added stored procedure  betalockinfo , error not repeated but we have already troubleshooted using sp_who2,sp_who3 and using blocked by handle we were able to locate pc and closed...

We are  using  dot net Application. When application opened SQL connection will be opened and it will be closed when application closed. The Extended property is updated using application  but ...

My  table created like this.

CREATE TABLE objects3(id  int  NULL, name varchar(1000)  NULL)
INSERT objects3 (id, name)
    SELECT object_id, encryptbypassphrase('Det är gurkor i...

The database is restored from Production database to the testing server.Is it possible to get information  from where it is calling.

Broker is disabled in the  database which is mentioned in error.but in other 2 database the service broker option is enabled.

Can this query be used to delete the queue.

            
August 14, 2020 at 10:18 am
            
#3780445

            
            
                                                
        

Using Sql trace i was able to get the Username but not the Query origin.

I used this Query.

Select * from Table_1

As i said earlier "In the license terms under the ‘Scope of License’ there mentioned “You may not publish the software for others to copy”."