sqlrockstar ✭✭✭✭✭

The calculation hasn't changed, it's just doing some math regarding the signal wait time and resource wait time. There could be many factors for the difference including hardware, virtual configuration, and even how wait events were classified between the versions. So, I wouldn't call it a bug, but it is possible that we…

I'm new here, still working my way around, but I believe this is something that is already being worked on: AppInsight for SQL

You should be able to do this quickly with a backup/restore and then editing the repo.properties file as outlined here: http://support.confio.com/kb/article/moving-sql-server-data-warehouse-repositories/1532/ For your case, I'd suggest the following: 1. Shutdown your current instance of DPA 2. Backup and restore the DPA…

You might get an answer faster by posting this in the NetFlow product forum instead.

This. Is. Awesome. Thanks for sharing!

It sounds like you want something akin to an auditing feature (since you mention DML and DDL). If that's what you are looking for, then I would suggest you use SQL Server Audit (assuming you are running version 2008+). You can capture DDL and DML statements as needed, output them to a file, and then use a tool like LEM for…

Nice!

I wouldn't advocate for "Azure-first", but I would advocate for "Cloud-first", where AWS and Azure were given equal priority.

Before moving from virtual to physical you should check to make certain you know where the bottleneck is, otherwise you may go through all the effort of a migration and still have performance issues.

The only possible explanation I have to offer is that your database was created prior to SQL 2005, upgraded to a more recent version at some point, and that option was left alone. My understanding is that since 2005 onwards, the default is CHECKSUM, unless you override, and there is no reason to override that setting. HTH

Was great seeing you again, and thanks for the recap! I'm already looking forward to next year!

Not sure, what is the "web report builder"? Is that a SWI provided tool? If so, and if this query works in SSMS, then it's likely the web report builder is throwing a syntax error of some kind. In cases like this I usually strip back the query and then add just one piece back at a time in order to find where the failure is…

Deadlocks are not a hardware issue, they are a database design issue. Using NOLOCK is not going to remove deadlocks, as NOLOCK is just another way of saying READ UNCOMMITTED, and neither is going to remove how SQL server acquires locks in order to perform transactions. So, your question is "when to use NOLOCK", and I'd…

Years ago I had put together a 1-day training session on DPA that I delivered for a customer. It walked through the items such as the concept of wait events, how DPA did collections, and how to make your own customizations. I think the idea of a comprehensive user guide is a good one, as DPA does have a lot of features and…

Angela, Sorry to hear about this, let me reach out to someone on the NPM team to understand more about the issue. Tom

This is not just an IT challenge. This is a human challenge. People fear what they don't understand. It's that simple. Show them something new, even something familiar, and there is something instinctive that comes out and says "do not like". Think about every time iTunes gets a facelift. You've been using it for almost 10…