Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
7
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Mar
29
awarded  Self-Learner
Mar
24
awarded  Teacher
Mar
24
answered Getting the error log location in an efficient way
Mar
24
comment Getting the error log location in an efficient way
@AaronBertrand good question - I was under the impression this could be inaccurate under certain circumstances, but now I am wondering if I am wrong on this one.
Mar
24
asked Getting the error log location in an efficient way
Mar
9
awarded  Scholar
Mar
9
comment What is the request_id in sys.dm_exec_requests and how does it change?
Excellent! Thank you so much :)
Mar
9
comment What is the request_id in sys.dm_exec_requests and how does it change?
@Shanky, I have my reasons, which is why I asked the question. Thankfully Dan gave me a constructive and excellent answer.
Mar
9
accepted What is the request_id in sys.dm_exec_requests and how does it change?
Mar
9
asked What is the request_id in sys.dm_exec_requests and how does it change?
Oct
22
awarded  Editor
Oct
22
revised Why does sys.fn_hadr_backup_is_preferred_replica take so long? Is there a better way?
added 372 characters in body
Oct
22
awarded  Supporter
Oct
21
asked Why does sys.fn_hadr_backup_is_preferred_replica take so long? Is there a better way?
Oct
12
comment Is there a Windows Performance Counter which contains the “Log Send Rate” for Availability Groups?
This is still not quite the same as the Log Send Rate kb/s as reported per database on the SSMS and as queryable via the DMV on the secondary. I would like a performance counter (which I can sample on the secondary replica) to give the same value as the log_send_rate in the sys.dm_hadr_database_replica_states table.
Oct
9
asked Is there a Windows Performance Counter which contains the “Log Send Rate” for Availability Groups?
May
8
awarded  Popular Question
Aug
10
awarded  Student
Aug
10
comment Best way to re-import large amount of data with minimal downtime
Thanks, another interesting alternative - I think the last two statements aren't quite right, should move shadow onto cache, and truncate cache. I wonder if Synonyms could also be used?
Aug
10
asked Best way to re-import large amount of data with minimal downtime