Export-DMVInformation halts at Query 40 when specifying -excludedb parameter on a 2008 R2 instance

[wsuhoey]

When I run Export-DMVInformation -instance 'my2008R2server', it gets to Query 42 (IO Stats By File), and then runs into an error after about a dozen databases Incorrect syntax near ')', which I could re-pro manually doing Glenn Berry's script in SSMS on the last database it hits, which told me it's not an issue with PowerShell but with Glenn's script. I realized that this particular database is at a lower compatibility level (SQL 2000, compat level 80) so Glenn's script throws an error since it's not for a SQL 2000 database.

So I then tried doing Export-DMVInformation -instance 'my2008R2server' -excludedb 'mycompat80db', and the PowerShell script stops at Query 40 (Ad hoc Queries), and doesn't go to Query 41 and above.

Hence, the bug seems to be when using -excludedb, it does not go beyond Query 40.

[sanderstad]

Thank you I will look at that From: wsuhoey [mailto:[email protected]] Sent: Wednesday, May 24, 2017 10:07 PM To: sanderstad/Export-DMVInformation <[email protected]> Cc: Subscribed <[email protected]> Subject: [sanderstad/Export-DMVInformation] Export-DMVInformation halts at Query 40 when specifying -excludedb parameter on a 2008 R2 instance (#5) When I run Export-DMVInformation -instance 'my2008R2server', it gets to Query 42 (IO Stats By File), and then runs into an error after about a dozen databases Incorrect syntax near ')', which I could re-pro manually doing Glenn Berry's script in SSMS on the last database it hits, which told me it's not an issue with PowerShell but with Glenn's script. I realized that this particular database is at a lower compatibility level (SQL 2000, compat level 80) so Glenn's script throws an error since it's not for a SQL 2000 database. So I then tried doing Export-DMVInformation -instance 'my2008R2server' -excludedb 'mycompat80db', and the PowerShell script stops at Query 40 (Ad hoc Queries), and doesn't go to Query 41 and above. Hence, the bug seems to be when using -excludedb, it does not go beyond Query 40. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#5> , or mute the thread <https://github.com/notifications/unsubscribe-auth/AF3q5ZvU4yqRPGwgxeC5ySI_hdhBdhtSks5r9I36gaJpZM4NlmsA> . <https://github.com/notifications/beacon/AF3q5eicMThpYmzIRrNtGai_ZjvUhIqiks5r9I36gaJpZM4NlmsA.gif>