Stack Overflow
Stack Overflow

Questions tagged [sql-server-mars]

Multiple Active Result Sets is a feature used on Microsoft's SQL Server to allow multiple batch execution on a single server

Multiple Active Results Sets is a technique used within Microsoft's SQL Server database management system to enable a single database connections to be used for multiple purposes.

Links

43 questions
1
vote
1 answer

Does Entity Framework 6 async parallel queries use Multiple Active Result Sets for connection pooling

I have some very large queries the EF is creating resulting in slow response times and high CPU use so I thought as a way to optimize I'd try to implement MARS and Async parallel queries to pull back multiple, simpler result sets in parallel and…
crichavin
  • 4,672
  • 10
  • 50
  • 95
1
vote
0 answers

Is it possible to have Multiple Active Result Sets from a Stored Proc execution using php sqlsrv?

I would like to be able to retrieve result sets from a Stored Proc execution using PHP and sqlsrv and have both resultsets available for reading at the same time. Is this possible ? Here a sample of what can be done, but without having 2 result sets…
MaxiWheat
  • 6,133
  • 6
  • 47
  • 76
1
vote
2 answers

Azure Backups Failing Due To Possible MARS Agent DLL Issue

We are running Microsoft Azure Backup Server (MABS) v3 on Windows Server 2019. Since Monday evening the cloud and bare-metal backups started failing, but other on-premises backups are running fine. Looking through Event Viewer we found an…
imort3rnal
  • 11
  • 1
1
vote
1 answer

How to disable OLE DB from opening additional implicit non-pooled connections?

OLE DB has a sneaky feature where if your current connection is busy, it will silently open more database connections. these happen without your knowledge and they are not taken from, or returned to, the connection pool With the SQL Server 2005…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
1
vote
1 answer

Specify MultipleActiveResultSets in SQL CLR Trigger

I have a SQL CLR Trigger that has a number of SqlDataReader calls in it (among other things), where in the production system users are getting errors like A .NET Framework error occurred during execution of user-defined routine or aggregate…
Conrad
  • 2,197
  • 28
  • 53
1
vote
0 answers

All RMSE values missing for bagEarth method in caret R

I'm trying to complete Exercise 3 from Chapter 7 of Applied Predictive Modeling (Max Kuhn), which uses a bagged MARS model. The code I'm using is straight from the solutions found here: Chapter 7 Solutions However, when I train the bagEarth…
sbearben
  • 323
  • 6
  • 16
1
vote
1 answer

Membership.GetUser() & MARS

I'm using asp.net membership, and need to make a call to Membership.GetUser() while I have another open SQL connection, but my code dies at that call. I have MultipleActiveResultSets=True in the connection string that is used by both my code and…
Scott Ivey
  • 40,768
  • 21
  • 80
  • 118
1
vote
1 answer

jaxb marshalling/unmarshalling exception in jboss servlet

I am trying to send marshalled jaxb data from a gwt server, and read it at reception in a servlet run by jboss. This is the code in the sending part: url = new URL(MessageFormat.format(urlStr,ip)); conn =…
yaron
  • 439
  • 6
  • 16
1
vote
2 answers

Cannot get variable from Child back to Parent in JAVA (Options Window)

STARTED - 3:00PM UPDATE 1 - 5:36PM Apply Button in the Option() class: private void cmdApplyActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: …
Adam Ray Bicknell
  • 11
  • 3
1
vote
2 answers

Is MARS required for multiple SELECT in multiple contexts for EF?

I use MySQL (it does not support MARS), and I try to run in parallel multiple SELECTs. The connection string is the same, however for each SELECT I create another db context. It looks like this: using (var db =…
greenoldman
  • 16,895
  • 26
  • 119
  • 185
1
vote
2 answers

MARS vs NextResult

I rehydrate my business objects by collecting data from multiple tables, e.g., SELECT * FROM CaDataTable; SELECT * FROM NyDataTable; SELECT * FROM WaDataTable; and so on... (C# 3.5, SQL Server 2005) I have been using batches: void…
Sisiutl
  • 4,915
  • 8
  • 41
  • 54
0
votes
1 answer

Pyodbc can't enable MARS even when SQL native client shows 'MARS: yes'

I am trying to connect to a SQL Server 2019 with MARS. First I have configured a system DSN in ODBC Data Sources, which shows MARS is enabled (ODBC driver 17). I have also tried SQL Server native client 11.0, which gives the same result. Then I…
clarence zhao
  • 1
  • 1
0
votes
1 answer

mips code that swap the bits of odd and even position

Write a MIPS program that asks the user to enter an unsigned number and read it. Then swap the bits at odd positions with those at even positions and display the resulting number. For example, if the user enters the number 9, which has binary…
wang
  • 1
0
votes
1 answer

MultipleActiveResultSets for SQL Server and VB.NET application

I am trying to get multiple data sets from SQL Server using a VB.NET application. The problem that every time I try to execute the query, I get this message: Cannot change property 'ConnectionString'. The current state of the connection is…
user9067306
0
votes
1 answer

How DbContext will be provided with connection instance from Connection pool?

We are using asp.net core 3.x with EF Core 3.x We do have authorization on couple of entities(so that it only allow few of the records from table returned as response) which is achieved by accessing SQL view (internally joins two table) and we query…
Jenish Rabadiya
  • 6,708
  • 6
  • 33
  • 62
1
2
3