User user9516827

5

11

votes

4

answers

31k

views

Memory Usage by SQL Server

Mar 29 at 13:40 Shanky 16.2k

10

votes

3

answers

358

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

1

7

votes

1

answer

266

views

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

sql-server ola-hallengren fragmentation index-maintenance

Aug 6 at 13:58 vijayakumar P 1

1

5

votes

2

answers

287

views

DBCC SHRINKFILE on the distribution database

sql-server replication transactional-replication shrink

Jun 12 at 14:56 Ramakant Dadhichi 1,682

1

4

votes

1

answer

94

views

Huge Heap Table and table compression on SQL Server 2016

sql-server disk-space fragmentation compression heap

Jun 15 at 10:00 RonJohn 253

4

votes

1

answer

2k

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

3

votes

1

answer

627

views

Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries

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

Sep 18 at 18:49 Community♦ 1

3

votes

1

answer

422

views

Identify Query Waiting on resources

sql-server performance parallelism blocking waits performance-tuning

Mar 8 at 16:51 Community♦ 1

3

votes

1

answer

760

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

3

votes

1

answer

492

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

2

votes

1

answer

2k

views

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

performance query-performance sql-server-2016 parallelism

Jan 10 at 16:58 user9516827 1,153

1

2

votes

1

answer

129

views

User connections without a login

sql-server performance connections session cpu performance-tuning

Dec 13 at 12:43 Community♦ 1

2

votes

1

answer

44

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

2

votes

2

answers

70

views

Failover strategy for SQL Server 2016 Standard Edition

sql-server replication transactional-replication log-shipping failover

Aug 13 at 20:21 BradC 8,547

2

votes

1

answer

290

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 Reinstate Monica♦ 51k

2

votes

1

answer

773

views

Connection pool Error

sql-server transaction connection-pooling timeout

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

2

votes

0

answers

105

views

Plan cache mystery

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

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

2

votes

2

answers

111

views

Does Query Plan cache gets cleared by itself?

sql-server optimization plan-cache plan-guides

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

2

votes

0

answers

173

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

308

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

114

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

72

views

Indexing Strategy for the query performance

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

Oct 17 at 19:42 Community♦ 1

2

1

vote

1

answer

92

views

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

sql-server index update bulk-insert

Jul 20 at 11:38 Chessbrain 627

1

vote

0

answers

19

views

Transactional Replication and distribution database size

sql-server transactional-replication disk-space datafile filegroups

Jun 12 at 13:16 user9516827 1,153

1

vote

1

answer

88

views

Server Principal SID showing as NULL and name as empty string

sql-server sql-server-2016 audit logins

Apr 4 at 16:50 user9516827 1,153

1

vote

1

answer

455

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

48

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

1

vote

1

answer

400

views

Slow Query with RESOURCE_SEMAPHORE wait info [closed]

sql-server memory wait-types plan-cache

Oct 23 '18 at 15:12 user9516827 1,153

1

vote

0

answers

62

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 17:17 Community♦ 1

1

vote

2

answers

68

views

Functions causing Serial plan.What to use instead? [closed]

sql-server performance functions parallelism

Oct 1 '18 at 13:24 user9516827 1,153

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

81 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'

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?

Execution time high for Query in sp_executesql

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

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

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?

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

Server Principal SID showing as NULL and name as empty string

Debug Connection Pool Error

SSRS default URL not being referenced from Windows application

Slow Query with RESOURCE_SEMAPHORE wait info [closed]

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

Functions causing Serial plan.What to use instead? [closed]