Reputation
440
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 8 23
Impact
~44k people reached

  • 0 posts edited
  • 3 helpful flags
  • 28 votes cast
1d
awarded  Popular Question
Aug
21
awarded  Good Question
Aug
19
awarded  Popular Question
Aug
4
awarded  Promoter
Jul
30
awarded  Popular Question
Jul
30
awarded  Popular Question
Jul
29
asked Connection Reset by Peer: Socket Write Error
Jun
30
comment Why are SELECT queries in sleeping status holding open transactions
@AaronBertrand Most are S LOCK GRANT but about 10 are Sch-S LOCK GRANT (resource_type = METADATA, resource_subtype = DATABASE_PRINICPAL, request_owner_type = 'TRANSACTION'), which still seems strange to me to see for a SELECT, but maybe that's normal. As you said, maybe I'm inventing a problem, but I want to be sure everything looks okay on the database side before I start pointing fingers at the application.
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