I am building an angularjs .net application with WebApi2 and SQL Server 2008.When page loads, it sends multiple ajax calls to WebApi. WebApi then in turn passes on these calls to Sql server, but when I look into sql profiler, all calls to db are executed with same SPID,which I believe is a sequential execution rather than parallel execution of stored procs. Even after having looking at the network monitor tab on firefox browser, all these calls return one after another and not at the same time.This might create bottleneck in the system , as angular sends parallel request to webapi but sql server is executing each request sequentially rather than parallel. I have used Data Access Application Block v6.0 and have put Connection and Command objects under "Using" scope. Still it fires all my storedproc with same SPID. Is there anything which I am doing wrong here?
Unique SPID for each stored procedure execution
713 Views Asked by Deeps At
0
There are 0 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in SQL-SERVER-2008
- Why does the following script throw database still in use when selecting the master database first?
- Return Duplicate Rows
- SQL Data entry - finding sequence to enter info
- Why is this query in SSMS showing columns/tables as numbers?
- Query from multiple tables based on the table name?
- How to Let Python Connect to a SQL Server Database
- Need to fetch Minimum value for Each Id and make the BidSuccess column to 1
- Spring Boot Scheduled Annotation Job Issue
- Use different WHERE clause based on condition?
- Error when inserting special characters such as Ñ and accents á, é, í, ó, ú. using BULK OPENROWSET from python
- Delete all records except the max value of a group
- How to use SQL Server stored procedures in React js express server
- Loop through date in SQL Server and exclude the dates within a range of one week
- Find amount greater than the average amount
- Update trigger - both INSERTED and DELETE hold same value after update
Related Questions in CONNECTION-POOLING
- How to configure connection pool c3p0 hibernate most efficiently for remote connection mySql
- Failed to connect to docker container running Postgres via pgbouncer
- How to establish connection pooling for HTTP Requests Lambda function attached to AWS API gateway?
- morphia client always makes more than 1 connection
- context deadline exceeded (Client.Timeout exceeded while awaiting headers)
- How to know DriverManagerDataSource has a connection pool
- How to view connection pool activity within Snowflake re: Looker?
- Why does connection pooling not work with pyodbc in my Linux image?
- SQLAlchemy QueuePool Overflow Issue in FastAPI Application with Uvicorn
- r2dbc-pool: Using the r2dbc connection pool slows down the execution of parallel transactions
- Jboss default idletimeout minutes if not mentioned
- How to efficiently define connection pool for multiple data sources with single database per tenant, in spring boot
- How to notify to reset tcp connection from target
- How to export Connection pool metrics of Tomcat like NumActive, NumIdle, MaxTotal via JMX exporte?
- AWS RDS Proxy avoid pinned connection with mysql and prepared statements
Related Questions in ASP.NET-WEB-API2
- Twilio ASP.NET Web Api Request Validation - 'Specified method is not supported' When Attempting To Read From Content Stream
- Hot to write a FileUpload method in a WebAPI using NSwag?
- How should I format an Angular POST to a WebAPI endpoint?
- How to configure route path to direct controller instead of getting method name
- Crystal Reports Export Takes Longer After Inactivity in Web API 2 Application
- Token validation failed. Unable to validate issuer
- I have combine Angular 9 frontend with ASP.NET 4.7 API backend in one solution file but server side sessions how can handle?
- How to implement drilldown grouping in swagger?
- Dapr PUB / SUB Setup for an ASP.NET Web API 2 (.NET Framework)
- Microsoft Web API 2 AuthenticationSchemes
- Unable to load IHttpModule using ASP.NET web application (Web API VB.NET code), it is always returning back an error "Could not load type"
- Can't get imageUrl
- .NET Blazor hosting on Nginx - API issue
- Endpoint on local API not working unless consumed endpoint is accessed first
- C#- AES256 Key Encryption using (RSA/ECB/PKCS1Padding) and Decryption using Java (RSA/ECB/PKCS1Padding)
Related Questions in SPID
- Lead Blocker Query
- SQL Server SPIDS go into a sleeping state and never recover
- Lock\Block on table with SPID -2
- T-SQL how to get more than last query executed by SPID from the cache (DBCC INPUTBUFFER, sys.sysprocesses)
- Get mac id of pc or laptop who Altered your db. SQL Server
- Different SPID in Status Bar than @@SPID
- SQL Server: how do I kill a -3 SPID?
- How can i find the process using the most memory by SPID?
- Is it possible situation: SQL Server use the same spid for two instances of same application?
- SQL Server Log - Souce (SPID)
- How to get Current System Process id in crystal report?
- Process/SPID is being blocked by itself, how to clear/kill without restarting Sql Server
- Remove a SPID after LINQ in Entity Framework
- Unique SPID for each stored procedure execution
- Stop C# Multi-Threaded Sql calls from using same SPID
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?