Reputation
547
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 18
Impact
~23k people reached

  • 0 posts edited
  • 0 helpful flags
  • 25 votes cast
11h
asked PAGEIOLATCH_SH and WRITELOG waits
1d
revised Different Disk Drive Same Backend Storage
added 711 characters in body
Aug
28
comment Different Disk Drive Same Backend Storage
Log files not set greatly so will shrink and resize correctly and see how it performs. Thanks.
Aug
27
revised Different Disk Drive Same Backend Storage
deleted 2 characters in body
Aug
25
asked Different Disk Drive Same Backend Storage
Aug
24
awarded  Popular Question
Aug
18
comment Create Database and LCK_M_S
it was the size of the pre-allocation causing the issue
Aug
18
accepted Create Database and LCK_M_S
Aug
17
comment Non Buffer Latch - Forefront Identity Manager
Our cost threshold is 50 and MAXDOP is 8 with 8 cores in the VM. In understanding this I have a query to pull out plans that have gone parallel along with costs. If this is a non-buffer wait though will I see these queries in the plan cache?
Aug
17
comment Non Buffer Latch - Forefront Identity Manager
I should have said there are 8 cores on this VM
Aug
17
comment Non Buffer Latch - Forefront Identity Manager
Maxdop is 8 and cost threshold is 50
Aug
14
asked Non Buffer Latch - Forefront Identity Manager
Aug
13
comment DBCC TempDB Space Usage
Sorry for the slow response, I will check out what columns there are in our largest table.
Aug
10
comment DBCC TempDB Space Usage
At the time the DBCC runs theres not a lot else going on no.
Aug
10
asked DBCC TempDB Space Usage
Aug
3
awarded  Popular Question
Aug
3
awarded  Popular Question
Jul
27
comment SQL Server Mirroring Removed
I have just started and stopped the end points and it looks to have sprung back into life. My question now is what can cause the end point to mess up like this?
Jul
27
comment SQL Server Mirroring Removed
2012 - I know but we had too
Jul
27
comment SQL Server Mirroring Removed
The databases are all In Recovery so looks like it as removed I believe