user avatar
user avatar
user avatar
Newbie-DBA
  • Member for 5 years, 3 months
  • Last seen this week
9 votes
1 answer
3k views

Updating statistics on 18 TB database

4 votes
0 answers
56 views

Planning for application upgrade which connects to SQL server database

3 votes
2 answers
56 views

Estimating the best restore time from saved backups in SQL Server

3 votes
1 answer
220 views

Understanding Stolen and foreign memory usage between 2 app database servers

3 votes
3 answers
556 views

Need help to understand tuning up a slow SQL server query [closed]

3 votes
1 answer
1k views

Login issues for the same SQL login on mirror server working fine on principal server

3 votes
2 answers
333 views

Blocking on readable secondary replica

3 votes
1 answer
275 views

Stuck REDO Thread of an availability group

3 votes
1 answer
169 views

Database Unallocated Space - Correct way to measure

2 votes
1 answer
91 views

LATCH_EX and CX_PACKETS for a stored proc seen when timing out

2 votes
0 answers
26 views

Controlling permissions for app team while assigning them ALTER ANY AG access

2 votes
1 answer
176 views

Reason why SQL Max memory expansion seems slow when migrated to newer version of SQL server

2 votes
1 answer
111 views

CHECKDB with default settings and parallelism involved [closed]

2 votes
2 answers
62 views

Issues with differential backup on random days

2 votes
1 answer
61 views

Avoiding Hash match to improve CPU usage for a specific query

1 vote
0 answers
503 views

Converting show-plan XML to graphical view plan

1 vote
2 answers
122 views

Help with tuning this UPDATE Query or possible re-write

1 vote
3 answers
104 views

Handle development issues when dealing with different collation for the instance/database setting

1 vote
3 answers
85 views

Shrinking data file to save disk space before migration

1 vote
1 answer
64 views

Avg write latency spikes for disk more than usual. Need help finding the culprit

1 vote
2 answers
56 views

Unable to understand correlation between MaxWorkers created and CPU utilization

1 vote
0 answers
49 views

Tracking Read/Write latency for SQL server on linux

1 vote
1 answer
278 views

Estimated recovery time and REDO queue size related to DB up time

0 votes
0 answers
30 views

Can we track historically or see queries on server is landing on which schedulers

0 votes
1 answer
57 views

How can i get AG dashboard values via SQL Query across all supported versions of SQL server

0 votes
2 answers
57 views

How can i tune below proc either by changing query or adding index

0 votes
1 answer
50 views

Understanding the load running on my SQL server

0 votes
0 answers
62 views

Readers blocking reader on readable secondaries

0 votes
1 answer
58 views

How do you handle maintenance window for DDL commands on Primary replicating to readable secondary AGs

0 votes
0 answers
319 views

Using gMSA account for SQL server reporting services