Oh, I thought it was 2008 compatible; just have to change a stored procedure in the setup script due to the DMV column changes. It was working fine until...

Does anyone think that I should try reinstalling the Dashboard again since it doesn't seem like anyone has encountered a problem like this?

I'm on 2008 R2 Enterprise 64-bit.

It's still a no go... No one ran into this problem before?

YES!!! Thank you everyone for all of your help! Hal is spot-on with my situation. Thank you, thank you!! :w00t:

Does anyone happen to know how to resolve this issue? :unsure:

Unfortunately, it's not saving the results to a file; it's trying to open a file. I do have the "Results To Grid" enabled and have tried the steps you...

It's still happening... Is there a way to change the F5 shortcut to just execute the query?

Thank you very much, Gail! I appreciate your quick response.

Have you tried...

Depends on your indexes. I wouldn't do option 3. If you choose option 2, you should use UNION ALL instead of UNION. Hope that helps.

Also, keep in mind that if you do an index reorganize, you will have to update the statistics. However, if you do an index rebuild, you will not since...

Things that may help is updating statistics with fullscan (depending on how large the table is, of course). Perhaps breaking up the stored procedure into mini-steps? Those are...

You have to:

1) Create filegroups

2) Create data files and associate them to the filegroups

3) Create partition function (which is by year)

4) Create partition scheme using the partition function

5) Recreate...

I apologize. Please find attached the .xls version of the sp_who2 results.

Does anyone happen to know if ALTER DATABASE WITH ROLLBACK IMMEDIATE or ALTER DATABASE WITH NO_WAIT...