Reputation
5,332
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
16 41
Newest
 Yearling
Impact
~418k people reached

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).
Jul
28
awarded  Caucus
Jul
16
comment AWS RDS query running extremely slowly
AMI is Amazon Machine Image. I'd still suggest you try to change your code a bit first. As for our tool, it focuses on gathering details about the queries that are running and what they are waiting for.