brianflynn

You mean like producing an .RDL to upload into SSRS?

Thanks sasha.blyakher! The comments help us understand the reasons for desired features. Don't forget to click the link to vote for feature requests that you also want. We are watching those votes closely and it influences our roadmap.

I agree deedsd, this could be very useful.

I'm glad you found a workable solution for now. I have voted this one up myself. Nice suggestion spaceman. And nice workaround gcp!

That's great Richard. Let me know if I can help!

Hey outersource, The support team just followed up with me. Sounds like a re-install did it, right? Just wanted to circle back and make sure you were all set. Let me know. -Brian

Hey outersource , I noticed this thread hadn't been responded on. Just letting you know that mandevil is on vacation this week. I'm checking with his team to see if there is an update, but you may not see it until next week when Rob is back. Sorry for the delay. I'll let you know if I find an answer for you before Rob is…

Of course if you're looking for at a glance pictures of progress, you might look at the dashboard (home page) and use the biggest winners/losers graphs. They show the instances that have seen the greatest increase and decrease in wait time. These can be helpful in proving to peers and managers that you are making big…

Yeah, I think you're good. Based on some reading, you're lucky to get over 85% using an ORM. It's difficult to tell without examining each of the queries as they came in to see what we expect should have recycled an execution plan. It's possible that when usage is high, you have a greater chance of procedure cache hits b/c…

It might be that the best way to clear up uncertainties is a screenshot of what product you are looking at. If we can get an SE on the call, that would be great. Are you already working with any Solarwinds reps like someone from Sales? I can reach out to them and help prepare them. Since you may not see this until…

Nice work! Little performance tip. Use select count(1) instead of select count(*). :-)

Oh, and if you are using IIS 7.0, I seem to recall that it has instrumentation to tell you the status of current requests!

Ahh! Thanks for letting us know. Not surprised you still have a SQL 2K. I was reading a blog the other day that many chimed in on about why they still have a SQL 2K instance running. It was a solid platform and some solutions built on it just can't justify a re-write for so many reasons which all stem from cost/benefit…

You may have to check out the WMI counters for another set that is used with ASP.NET v4. It's been a while since I did this and unfortunately the online documentation leaves a lot to be desired. I do recall that there was a version of ASP.NET that was newer than v2 that were still using those counters. I also suggest…

Interesting. I think you may want to check out some of those links I posted above. It could be that you need to optimize for ad-hoc query loads. It does seem like compile counts are higher when the cache hit ratio is higher. That seems to support that theory. If so, I don't think these procedure cache hit ratios are bad at…

I think the definition we posted for this metric should be updated. It should first state that there is nothing inherently wrong with SQL Server’s total memory equaling the target memory thus resulting in this metric equaling zero. If Total Server Memory is less than Target Server Memory, resulting in this metric being a…

Oh. Maybe you don't have DPA installed then, b/c of the way you're saying Orion Platform 2014.1.0. That is not a DPA version number. So if you are interested in a deeper dive into DPA, I can have an SE follow up with you. Would you like me to do that?

Here's a blog post that may answer such questions. Yes, they are designed to run at the same time but I advise running them on different servers.

It could be a couple of things. It could be that it's waiting on a sleeping thread that is sleeping because it's waiting on another thread... which may be sleeping for the same reason etc. If you aren't seeing deadlocks, sounds like that's the case. My suspicion would increase if both/all SPIDs are executing the same SQL.

Looks like jaminsql has provided the answer. Thanks jaminsql!

Deltona, I'm wondering if it is even the SQL Server response time that is the issue. Have you investigated the IIS side? I've seen thread starvation issues where everyone assumed that the problem was database response time b/c the web server had low resource utilization (CPU, Mem & disk). You might try testing in a time…

I should add that while this may work, it's not the recommended configuration. As with anything in "it depends" on your situation. If the servers have enough physical resources for both systems, it can be fine. 

I found a solution you could do with DPA. I suggest a multi-numeric return custom alert. You could return the top SQL text with the number of compiles and recompiles. If you need help, I suggest submitting a support ticket. Our support team is great with these things.

Yes and no... The Storage I/O feature presents them as storage-wait vs non-storage-wait. You will see the detailed wait types in the Trends section. For example, in SQL Server, PAGEIOLATCH_XX and WRITELOG are the most common storage wait types. However the Trends section doesn't group them by I/O and non-I/O. The…

Hey spaceman & cwong, I spoke to our support team manager. He says he thinks these things can be timing/refresh issues. The currently blocked sessions don't update instantly. It only updates when the current page refreshes. So it could say 2 blocking sessions for the interval between refreshes when in reality when they…

I don't yet know if it is possible but I am checking on it...

Sorry, no Database Monitor 9.0 at this time. However, you could take advantage of the new floating license for Development and UAT environments that only need occasional monitoring. In doing so, you'd get the full set of features to use as needed on any of your Development/UAT database instances.

To limit the amount of memory SQL Server uses... * Open Management Studio * Connect to your database instance * Right click on the database instance then choose "Properties" * Select "Memory" from the upper left * Specify your minimum and maximum. I have limited this one to 3GB *

Hi sevenup679‌. I'm going to follow up with you by email.

Unfortunately, we have a policy of not promising release dates so I can't give you such an answer. I just wanted you to know that it's already being worked on. I'll email you to set up a call. I'll use the email on your profile here. :-)