Reputation
543
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 8 23
Impact
~60k people reached

  • 0 posts edited
  • 3 helpful flags
  • 35 votes cast
Jun
30
comment Why are SELECT queries in sleeping status holding open transactions
@AaronBertrand The vendor is insisting that there are database problems, but they can't say what, so I am doing some digging. I am not seeing any deadlocks. In a perfect scenario in which the applications are committing or rolling back all transactions, should I not see any sleeping user processes?
Jun
30
comment Why are SELECT queries in sleeping status holding open transactions
@AaronBertrand No, the processes are spid > 50, so they are user processes. They are coming from a vendor application. The handful that I spot-checked are very simple queries selecting just a few columns from small tables. Many of the queries are even selecting from a table with 1 row. Some of these have been sleeping for 12 hours now.
Jun
30
comment Why are SELECT queries in sleeping status holding open transactions
@Shanky Is it possible that the older tables have data that is not accurate? I do not see the sleeping transactions in sys.dm_exec_requests
Jun
30
asked Why are SELECT queries in sleeping status holding open transactions
Jun
12
awarded  Notable Question
May
30
awarded  Famous Question
May
7
awarded  Notable Question
Apr
8
awarded  Tumbleweed
Apr
1
asked SSIS Export to flat file with fixed column widths - add record with a different format?
Mar
13
comment Security for SSIS packages in SQL Server - use a domain account?
Ideally, I am thinking a non-expiring service account on the domain would work. If I just have "Windows Authentication" selected on the connection managers in the package, when it runs in a job, it runs completely under the context of the SQL Server Agent account, not my account, right? If I create a service account that can access Server B, and then set up an SSIS proxy with a credential on Server A, would that keep everything running under the service account?
Mar
12
asked Security for SSIS packages in SQL Server - use a domain account?
Mar
12
awarded  Popular Question
Feb
24
awarded  Popular Question
Dec
31
awarded  Yearling
Dec
8
awarded  Notable Question
Nov
24
asked How to maintain database ownership restoring across domains?
Oct
12
awarded  Popular Question
Sep
24
awarded  Autobiographer
Jul
3
comment When should I NOT set the Maximum Server Memory option in SQL Server?
I have also seen Jonathan's recommendations, among others. The problem is that they account for only the SQL Server engine running on the server, and not SSIS, SSAS, etc.
Jul
3
asked When should I NOT set the Maximum Server Memory option in SQL Server?