User user9516827

8

14

votes

4

answers

60k

views

Memory Usage by SQL Server

Mar 8 at 9:25 Shanky 17.5k

10

votes

3

answers

526

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 19 '19 at 18:33 Community♦ 1

1

7

votes

1

answer

428

views

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

sql-server ola-hallengren fragmentation index-maintenance

Aug 6 '19 at 13:58 vijayakumar P 1

1

5

votes

2

answers

977

views

DBCC SHRINKFILE on the distribution database

sql-server replication transactional-replication shrink

Jun 12 '19 at 14:56 Ramakant Dadhichi 2,138

1

4

votes

1

answer

146

views

Huge Heap Table and table compression on SQL Server 2016

sql-server disk-space fragmentation compression heap

Jun 15 '19 at 10:00 RonJohn 344

4

votes

1

answer

5k

views

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

sql-server sql-server-agent jobs

Aug 28 '18 at 21:39 Erik Darling 31k

1

4

votes

1

answer

911

views

Execution time high for Query in sp_executesql

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

Jun 21 '18 at 14:33 Community♦ 1

3

votes

1

answer

3k

views

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

performance query-performance sql-server-2016 parallelism

Oct 28 at 17:25 Hannah Vernon♦ 64.3k

3

votes

1

answer

921

views

Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries

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

Sep 18 '19 at 18:49 Community♦ 1

3

votes

1

answer

618

views

Identify Query Waiting on resources

sql-server performance parallelism blocking waits performance-tuning

Mar 8 '19 at 16:51 Community♦ 1

3

votes

1

answer

1k

views

Memory Pressure in SQL Server - Enable LPIM or not?

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

Nov 5 '18 at 7:59 Community♦ 1

1

2

votes

1

answer

286

views

User connections without a login

sql-server performance connections session cpu performance-tuning

Dec 13 '19 at 12:43 Community♦ 1

2

votes

1

answer

59

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 11 '19 at 14:26 Community♦ 1

2

votes

2

answers

128

views

Failover strategy for SQL Server 2016 Standard Edition

sql-server replication transactional-replication log-shipping failover

Aug 13 '19 at 20:21 BradC 9,191

2

votes

1

answer

365

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 16:50 Paul White♦ 59.7k

2

votes

1

answer

2k

views

Connection pool Error

sql-server transaction connection-pooling timeout

Oct 3 '18 at 13:13 David Browne - Microsoft 32.4k

2

votes

0

answers

646

views

SQL Buffer Pool and Plan cache

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

Jul 24 '18 at 20:59 user9516827 1,227

2

votes

0

answers

119

views

Plan cache mystery

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

Jul 24 '18 at 12:54 user9516827 1,227

2

votes

2

answers

258

views

Does Query Plan cache gets cleared by itself?

sql-server optimization plan-cache plan-guides

Jul 23 '18 at 17:10 user9516827 1,227

2

votes

0

answers

237

views

Plan Guide for the LINQ-SQL Query

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

Jul 20 '18 at 13:22 Community♦ 1

2

votes

3

answers

411

views

Serial Plan in plan cache

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

Jul 18 '18 at 10:36 Community♦ 1

2

votes

0

answers

144

views

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

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

Jun 22 '18 at 15:56 Community♦ 1

1

vote

2

answers

372

views

SQL Server : Memory pressure,Spiked user connections and CPU usage [closed]

sql-server locking performance performance-tuning query-performance

Mar 6 at 10:54 Stephen Morris - Mo64 2,615

1

vote

1

answer

93

views

Indexing Strategy for the query performance

sql-server index-tuning performance covering-index performance-tuning

Oct 17 '19 at 19:42 Community♦ 1

1

vote

3

answers

710

views

Create Synonym error for a user-SQL Server

sql-server permissions schema synonyms

Aug 10 '19 at 12:17 Dan Guzman 21.4k

2

1

vote

1

answer

373

views

Inserting few millions of rows: Does indexing happens along with the insert operation

sql-server index update bulk-insert

Jul 20 '19 at 11:38 Chessbrain 729

1

vote

0

answers

35

views

Transactional Replication and distribution database size

sql-server transactional-replication disk-space datafile filegroups

Jun 12 '19 at 13:16 user9516827 1,227

1

vote

1

answer

259

views

-skipErrors in Transactional Replication not happening

sql-server replication sql-server-2016 transactional-replication

Jun 12 '19 at 1:58 Jerry Hung 132

1

vote

1

answer

216

views

Server Principal SID showing as NULL and name as empty string

sql-server sql-server-2016 audit logins

Apr 4 '19 at 16:50 user9516827 1,227

1

vote

1

answer

668

views

Debug Connection Pool Error

sql-server performance connection-pooling performance-tuning query-performance

Feb 7 '19 at 21:09 Community♦ 1

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

75 Questions

Memory Usage by SQL Server

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

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

DBCC SHRINKFILE on the distribution database

Huge Heap Table and table compression on SQL Server 2016

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

Execution time high for Query in sp_executesql

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

Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries

Identify Query Waiting on resources

Memory Pressure in SQL Server - Enable LPIM or not?

User connections without a login

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

Failover strategy for SQL Server 2016 Standard Edition

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

Connection pool Error

SQL Buffer Pool and Plan cache

Plan cache mystery

Does Query Plan cache gets cleared by itself?

Plan Guide for the LINQ-SQL Query

Serial Plan in plan cache

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

SQL Server : Memory pressure,Spiked user connections and CPU usage [closed]

Indexing Strategy for the query performance

Create Synonym error for a user-SQL Server

Inserting few millions of rows: Does indexing happens along with the insert operation

Transactional Replication and distribution database size

-skipErrors in Transactional Replication not happening

Server Principal SID showing as NULL and name as empty string

Debug Connection Pool Error