125 reputation
5
bio website MichaelJSwart.com
location Waterloo, Canada
age
visits member for 4 years, 4 months
seen Nov 14 at 16:06

See my website for more about me: http://michaeljswart.com/?page_id=2


Oct
11
accepted Is there a way to fake “slow” storage for testing?
Oct
10
awarded  Commentator
Oct
10
comment Is there a way to fake “slow” storage for testing?
Fair enough. Thanks Tim.
Oct
10
comment Is there a way to fake “slow” storage for testing?
Yes, an old usb stick to test on would be sufficient.
Oct
10
asked Is there a way to fake “slow” storage for testing?
Aug
3
comment What SQL Server Query will set perfmon counter “Longest Transaction Running Time” > 0
I've had varied results when using connect and I've given up for small issues. See michaeljswart.com/?p=8 and michaeljswart.com/?p=13 and connect.microsoft.com/SQLServer/feedback/details/349116
Jul
30
comment What SQL Server Query will set perfmon counter “Longest Transaction Running Time” > 0
I got to see something on another server, but not consistently! Which is more weight to the conclusion not to trust the counter :-( squillman, thanks for your help.
Jul
29
accepted What's the best way to monitor SQL Server Concurrency issues?
Jul
29
awarded  Scholar
Jul
29
awarded  Supporter
Jul
29
accepted What SQL Server Query will set perfmon counter “Longest Transaction Running Time” > 0
Jul
29
comment What SQL Server Query will set perfmon counter “Longest Transaction Running Time” > 0
Thanks Mark... sounds like it's not a counter to be trusted.
Jul
29
comment What SQL Server Query will set perfmon counter “Longest Transaction Running Time” > 0
No luck :-( You mentioned that it "should" give a value in that counter. Have you seen it on your own machine?
Jul
29
comment What SQL Server Query will set perfmon counter “Longest Transaction Running Time” > 0
Here's SQL Server's @@VERSION: -------- Microsoft SQL Server 2008 (RTM) - 10.0.1763.0 (Intel X86) Sep 18 2008 21:13:29 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
Jul
29
asked What SQL Server Query will set perfmon counter “Longest Transaction Running Time” > 0
Jul
29
answered What's the best way to monitor SQL Server Concurrency issues?
Jul
23
comment What's the best way to monitor SQL Server Concurrency issues?
Thanks for your answer Nick! I was hoping for a metric that could catch potential trouble before they become a problem. If I'm catching deadlock graphs, it's too late to prevent them. The blocked process might be promising with a low enough threshold, but in terms of a measure or a performance indicator, the best I could do is count them. I know there are wait statistics, but I wonder how useful these are...
Jul
23
awarded  Student
Jul
22
comment What's the best way to monitor SQL Server Concurrency issues?
SQL Server 2005. Took a look at the DMV All Stars queries. They look promising. I'll 1) look at wait stats, or realtime blockers 2) determining trends, tying back to the app if possible 3) take action to prevent problems. Step 1 and 2 are tricky here.
Jul
22
comment What's the best way to monitor SQL Server Concurrency issues?
SQL Server 2005