User user9516827

8

13

votes

4

answers

57k

views

Memory Usage by SQL Server

Oct 26 at 16:21 Aleksey Vitsko 3,001

10

votes

3

answers

508

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

415

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

883

views

DBCC SHRINKFILE on the distribution database

sql-server replication transactional-replication shrink

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

1

4

votes

1

answer

142

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 30.9k

1

4

votes

1

answer

875

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

2k

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.1k

3

votes

1

answer

899

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

603

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

257

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

58

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

123

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,141

2

votes

1

answer

348

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♦ 58.9k

2

votes

1

answer

2k

views

Connection pool Error

sql-server transaction connection-pooling timeout

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

2

votes

0

answers

630

views

SQL Buffer Pool and Plan cache

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

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

2

votes

0

answers

118

views

Plan cache mystery

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

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

2

votes

2

answers

245

views

Does Query Plan cache gets cleared by itself?

sql-server optimization plan-cache plan-guides

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

2

votes

0

answers

234

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

406

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

135

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

1

answer

324

views

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

sql-server locking performance performance-tuning query-performance

41m ago Community♦ 1

1

vote

1

answer

91

views

Indexing Strategy for the query performance

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

Oct 17 '19 at 19:42 Community♦ 1

2

1

vote

1

answer

335

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 709

1

vote

0

answers

33

views

Transactional Replication and distribution database size

sql-server transactional-replication disk-space datafile filegroups

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

1

vote

1

answer

232

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

197

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,207

1

vote

1

answer

639

views

Debug Connection Pool Error

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

Feb 7 '19 at 21:09 Community♦ 1

1

vote

0

answers

63

views

SSRS default URL not being referenced from Windows application

sql-server ssrs ssl ssrs-2016

Jan 2 '19 at 22:06 Randolph West 3,400

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

Indexing Strategy for the query performance

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

SSRS default URL not being referenced from Windows application