Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

PSINFO No Longer Working on SQL2012 Expand / Collapse
Author
Message
Posted Friday, May 10, 2013 8:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 12:59 PM
Points: 4, Visits: 279
I have a process which leverages PSINFO via. XP_CMDSHELL and unfortunately this functionality no longer works under SQL2012. oddly, I could not find any information regarding a behavioral change that would effect this functionality but it appears to no longer perform as expected.

As an example:
EXEC xp_cmdshell 'Psinfo -d disk'

Returns the volume information correctly on all prior SQL Server versions however, it simply hangs on SQL2012. The initiating SPID will simply wait indefinitely on PREEMPTIVE_OS_PIPEOPS.
Post #1451622
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse