User BeginnerDBA

3 votes

1 answer

210 views

Availability Group- Redo Rate displayed on AG Dashboard vs Perfmon counter

asked May 12, 2021 at 14:32

2 votes

3 answers

1k views

Urgent help with TempDB log file growth mystery

asked Apr 10, 2021 at 5:50

0 votes

0 answers

26 views

Aborting long running query under AG configuration [duplicate]

asked Mar 26, 2021 at 16:29

2 votes

1 answer

300 views

Longer time to bring SQL online after node failover

asked Jan 29, 2021 at 18:48

4 votes

3 answers

609 views

General Question on sp_recompile

asked Jan 19, 2021 at 20:02

0 votes

1 answer

334 views

High CPU for SQL server running on VmWare

asked Jan 8, 2021 at 22:11

0 votes

1 answer

253 views

Question on compression for very large tables in sql server

asked Nov 24, 2020 at 17:59

0 votes

2 answers

109 views

How to plan bring down the space used by databases to as low as possible

asked Oct 29, 2020 at 19:42

4 votes

2 answers

4k views

log send queue size and redo queue size in AG

asked Oct 19, 2020 at 22:44

0 votes

1 answer

132 views

How to fix below blocking problem on SQL server 2014

asked Oct 18, 2020 at 4:55

0 votes

1 answer

55 views

Getting VLF info with least privileged to run across multiple servers of different version

asked Oct 6, 2020 at 14:42

4 votes

1 answer

206 views

Suddenly SQL server restarted with pending task count increased

asked Sep 22, 2020 at 15:31

5 votes

1 answer

7k views

Best practices for SQL Server block size while formatting disks for data and log files

asked Aug 3, 2020 at 17:29

3 votes

1 answer

564 views

What could cause a sleeping session to have an open transaction?

asked Jul 10, 2020 at 1:51

0 votes

0 answers

80 views

Troubleshooting an automatic failover in 2 node multi subnet AG

asked Jul 7, 2020 at 0:20

1 vote

0 answers

36 views

How statistics play a major role in legacy CE vs new CE

asked Jun 21, 2020 at 19:11

0 votes

1 answer

45 views

Collecting VLF information on all versions of SQL server

asked Jun 18, 2020 at 18:47

0 votes

1 answer

93 views

How do get correct instance name on Multi instance cluster

asked Jun 17, 2020 at 20:56

3 votes

2 answers

206 views

Changing database compatibility from legacy CE to 120

asked Jun 2, 2020 at 20:32

4 votes

1 answer

729 views

Compatibility mode change does not reflect on secondaries

asked May 28, 2020 at 23:42

1 vote

1 answer

342 views

Need advice on how to migrate from existing database mirroring to availability groups

asked May 25, 2020 at 16:57

1 vote

2 answers

129 views

How can I optimize and speed up a query [closed]

asked May 22, 2020 at 2:24

2 votes

2 answers

320 views

Performance of Query where time captured from SP statement completed differs by large from RPC completed

asked May 20, 2020 at 19:27

-1 votes

1 answer

436 views

General Question as best practice to collect data from extended events

asked Apr 30, 2020 at 17:15

1 vote

1 answer

183 views

Setting MAX memory for SQL servers depending upon the model of CPU

asked Apr 17, 2020 at 17:17

1 vote

2 answers

116 views

Measuring the need of Capacity or scaling SQL server

asked Mar 30, 2020 at 18:07

0 votes

0 answers

51 views

Quick question on Scalar UDF's

asked Mar 25, 2020 at 17:43

1 vote

1 answer

2k views

Using NUMA Nodes with SQL Server

asked Mar 11, 2020 at 21:07

0 votes

1 answer

168 views

Unable to get actual execution plan for SQL Server 2014 SP3

asked Mar 4, 2020 at 19:19

2 votes

2 answers

1k views

Setting up Availability group for report server databases

asked Feb 3, 2020 at 15:37

Stack Exchange Network

129 Questions

Availability Group- Redo Rate displayed on AG Dashboard vs Perfmon counter

Urgent help with TempDB log file growth mystery

Aborting long running query under AG configuration [duplicate]

Longer time to bring SQL online after node failover

General Question on sp_recompile

High CPU for SQL server running on VmWare

Question on compression for very large tables in sql server

How to plan bring down the space used by databases to as low as possible

log send queue size and redo queue size in AG

How to fix below blocking problem on SQL server 2014

Getting VLF info with least privileged to run across multiple servers of different version

Suddenly SQL server restarted with pending task count increased

Best practices for SQL Server block size while formatting disks for data and log files

What could cause a sleeping session to have an open transaction?

Troubleshooting an automatic failover in 2 node multi subnet AG

How statistics play a major role in legacy CE vs new CE

Collecting VLF information on all versions of SQL server

How do get correct instance name on Multi instance cluster

Changing database compatibility from legacy CE to 120

Compatibility mode change does not reflect on secondaries

Need advice on how to migrate from existing database mirroring to availability groups

How can I optimize and speed up a query [closed]

Performance of Query where time captured from SP statement completed differs by large from RPC completed

General Question as best practice to collect data from extended events

Setting MAX memory for SQL servers depending upon the model of CPU

Measuring the need of Capacity or scaling SQL server

Quick question on Scalar UDF's

Using NUMA Nodes with SQL Server

Unable to get actual execution plan for SQL Server 2014 SP3

Setting up Availability group for report server databases