Reputation
5,585
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
16 42
Newest
 Nice Answer
Impact
~451k people reached

Mar
31
awarded  Nice Answer
Mar
4
comment SQL Server Audit could not write to the security log during busy periods
Could you provide more details? Are you using a delay (async writes), or are you logging synchronously? What is the CPU configuration, and is this a VM?
Jan
10
awarded  Yearling
Dec
30
comment Best Practices to reconfigure SQL Server for VMware
Just a guess, but perhaps they combined three servers into one VM, and the original boxes had 8, 8, and 4 CPU, so they went with 20 vCPU here.
Nov
2
awarded  Revival
Oct
22
comment Is storing attributes in separate tables instead of columns a standard practice?
@jkavalik Thanks!
Oct
21
comment Is storing attributes in separate tables instead of columns a standard practice?
Quick comment about performance, you should examine what wait events your queries are seeing. I seem to recall that the default engine (InnoDB) uses table level locking which ends up causing performance issues for simple activities like user logins. If you need a tool that can help with MySQL performance, check out DPA from Solarwinds (disclaimer, I work for Solarwinds) solarwinds.com/database-performance-analyzer-mysql.aspx
Oct
14
answered How to find out how much i/o resources a task, session, request or transaction is currently using?
Oct
13
comment How to find out how much i/o resources a task, session, request or transaction is currently using?
The XML showplan has the 'ActualPhysicalReads' element, maybe you could parse this out? schemas.microsoft.com/sqlserver/2004/07/showplan
Oct
8
comment How to find out how much i/o resources a task, session, request or transaction is currently using?
Have you looked at the sys.dm_io_virtual_file_stats DMV?
Oct
8
comment How to find out how much i/o resources a task, session, request or transaction is currently using?
Those are physical I/O tasks, so I'm not sure they would report logical I/O. In other words, if the page is already in memory, then there is no pending I/O.
Sep
23
awarded  Nice Answer
Sep
18
awarded  Enlightened
Sep
18
awarded  Nice Answer
Sep
4
reviewed Approve SQL Server email function invalid syntax
Aug
15
awarded  Nice Answer
Aug
14
answered Does a database backup include all files?
Aug
4
awarded  Constituent
Jul
28
awarded  Self-Learner
Jul
28
comment Should I restore without the log file?
He could detach and then reattach without a log. (Not saying he should, just that he could).