SQLPS slow to load on Server 2012

Hi all,

It takes about 20-30sec to perform "Import-Module SQLPS -disablenamechecking" on a "Windows Server 2012".

Any ideas on how to speed this on up? 

Kind regards,

Bart.

  • Moved by Bill_Stewart Tuesday, November 12, 2013 2:13 PM Moving to more appropriate forum
November 12th, 2013 4:37pm

It seems to me that this  kind of question would stand a better chance of being answered in the SQLServer forum for this version of SQS.

Free Windows Admin Tool Kit Click here and download it now
November 12th, 2013 5:09pm

So, I,ve been looking at the SQLPS.PSD1 and I see there is a SqlPsPostScript.ps1 in the nestedmodules.

NestedModules = @("Microsoft.SqlServer.Management.PSSnapins.dll","Microsoft.SqlServer.Management.PSProvider.dll", "SqlPsPostScript.ps1")

If I ommit SqlPsPostScript.ps1, all loads fast. I'm probably missing some functionality that way, but since I'm only using the module here to do some basic SQL qerying, this is fine for me.

Maybe someone has more insight in what's happening with that SqlPsPostScript.ps1 and why it's taking so much time to load?

November 14th, 2013 6:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics