User user9516827

4 answers

15 votes

73k views

8 bookmarks

Memory Usage by SQL Server

Jul 23 '18 at 22:01

3 answers

10 votes

625 views

Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode

sql-server performance parallelism functions performance-tuning query-performance

Apr 18 '19 at 21:26

1 answers

7 votes

527 views

1 bookmarks

Index fragmentation problem after disabling page-level locking for an Index

sql-server ola-hallengren fragmentation index-maintenance

Jul 12 '19 at 14:22

2 answers

5 votes

1k views

1 bookmarks

DBCC SHRINKFILE on the distribution database

sql-server replication transactional-replication shrink

Jun 12 '19 at 13:35

1 answers

5 votes

8k views

1 bookmarks

INSERT failed in SQL Job because of incorrect SET options 'QUOTED_IDENTIFIER'

sql-server sql-server-agent jobs

Aug 28 '18 at 20:51

1 answers

4 votes

1k views

Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries

sql-server performance execution-plan memory-grant query-performance

Oct 24 '18 at 20:15

1 answers

4 votes

1k views

1 bookmarks

Execution time high for Query in sp_executesql

sql-server performance execution-plan dynamic-sql query-performance

Jun 11 '18 at 20:14

1 answers

4 votes

178 views

1 bookmarks

Huge Heap Table and table compression on SQL Server 2016

sql-server disk-space fragmentation compression heap

Jun 14 '19 at 15:11

1 answers

3 votes

1k views

Memory Pressure in SQL Server - Enable LPIM or not?

sql-server sql-server-2016 memory performance performance-tuning

Oct 23 '18 at 17:19

1 answers

3 votes

692 views

Identify Query Waiting on resources

sql-server performance parallelism blocking waits performance-tuning

Jan 4 '19 at 19:14

1 answers

3 votes

3k views

Query runs in parallel but it is showing as blocked by itself

performance query-performance sql-server-2016 parallelism

Jan 9 '20 at 20:07

1 answers

2 votes

440 views

1 bookmarks

User connections without a login

sql-server performance connections session cpu performance-tuning

Dec 5 '19 at 15:15

1 answers

2 votes

65 views

Does enabling LPIM work even if the memory pressure is coming from SQL Server itself

sql-server sql-server-2016 memory performance plan-cache performance-tuning

Dec 6 '19 at 15:44

2 answers

2 votes

163 views

Failover strategy for SQL Server 2016 Standard Edition

sql-server replication transactional-replication log-shipping failover

Aug 13 '19 at 19:31

0 answers

2 votes

163 views

SORT(DISTINCT) :Is it because of Kitchen sink queries?

sql-server performance sort-operator performance-tuning query-performance

Jun 22 '18 at 15:39

0 answers

2 votes

709 views

SQL Buffer Pool and Plan cache

sql-server-2016 dynamic-sql plan-cache buffer-pool

Jul 24 '18 at 19:51

3 answers

2 votes

431 views

Serial Plan in plan cache

sql-server performance optimization parallelism plan-cache query-performance

Jul 16 '18 at 21:23

0 answers

2 votes

256 views

Plan Guide for the LINQ-SQL Query

sql-server performance dynamic-sql plan-cache plan-guides query-performance

Jul 19 '18 at 21:01

2 answers

2 votes

331 views

Does Query Plan cache gets cleared by itself?

sql-server optimization plan-cache plan-guides

Jul 20 '18 at 15:31

0 answers

2 votes

124 views

Plan cache mystery

sql-server sql-server-2016 execution-plan plan-cache plan-guides

Jul 23 '18 at 19:20

1 answers

2 votes

2k views

Connection pool Error

sql-server transaction connection-pooling timeout

Oct 2 '18 at 17:28

1 answers

2 votes

392 views

Using Resource Governor and allocate more memory to satisfy high Memory Grant request by queries?

sql-server memory waits resource-governor

Oct 23 '18 at 14:45

0 answers

1 votes

109 views

Used a CAST function ,still IMPLICIT Conversion warning in Execution Plan

sql-server performance execution-plan datatypes cast query-performance

Oct 22 '18 at 16:16

2 answers

1 votes

78 views

Functions causing Serial plan.What to use instead?

sql-server performance functions parallelism

Sep 28 '18 at 19:12

1 answers

1 votes

559 views

SQL Queries Slow in the Upgraded environment

sql-server execution-plan index-tuning performance performance-tuning query-performance

Jun 8 '18 at 19:08

0 answers

1 votes

540 views

Scalar function with while loop to TVF

sql-server performance set-returning-functions query-performance

Jun 27 '18 at 21:58

2 answers

1 votes

516 views

Transaction Replication:Intialize from Backup

sql-server replication transactional-replication

Aug 1 '18 at 3:23

1 answers

1 votes

144 views

Finding Serial plan from Plan cache

sql-server execution-plan parallelism plan-cache

Aug 10 '18 at 13:12

0 answers

1 votes

157 views

Cannot find query in plan cache and query execution times different for different paramters

sql-server execution-plan performance plan-cache performance-tuning query-performance

Jun 21 '18 at 14:20

2 answers

1 votes

420 views

Symantec Backup Exec runing DBCC CheckDB and Backup on my SQL server

sql-server backup dbcc-checkdb process

Jun 21 '18 at 17:28

Stack Exchange Network

current community

your communities

more stack exchange communities

75 Questions