Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Data Warehousing
»
Integration Services
»
Warning: Could not open global shared memory...
Warning: Could not open global shared memory to communicate with performance DLL
Rate Topic
Display Mode
Topic Options
Author
Message
Welsh Corgi
Welsh Corgi
Posted Tuesday, March 20, 2012 4:47 PM
Hall of Fame
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833,
Visits: 4,052
I'm a Local Admin on this Database Server but I get the following warning?
[SSIS.Pipeline] Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
Any ideas?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1269931
sam.dahl
sam.dahl
Posted Tuesday, March 20, 2012 5:19 PM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 7:49 PM
Points: 364,
Visits: 736
I get this error on one particular client site.
Google has plenty of suggestions, but given that we were not impacted by the error we never bothered resolving it.
To quote Todd McDermid here:
http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/d3c33c35-8c94-457d-9031-7b19803080d0
This is only a warning.
SSIS packages attempt to update performance counters on the machine they are executing on. But write access to those performance counters is restricted in order to prevent malicious use. Typically, packages are not executed with administrative priviliges, which are the default access level for writing to those counters.
To resolve, you can:
Ignore the message. You probably aren't monitoring those counters anyway.
Give the account your packages are executing under permission to update those performance counters.
Change the account your packages are executing under to grant them admin privileges.
I'd recommend #1 unless you need those counters.
Post #1269945
Welsh Corgi
Welsh Corgi
Posted Tuesday, March 20, 2012 5:29 PM
Hall of Fame
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833,
Visits: 4,052
Ok, Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1269951
brian.geregach
brian.geregach
Posted Wednesday, November 14, 2012 1:20 PM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:12 AM
Points: 10,
Visits: 18
did you ever resolve this issue? I'm experiencing the same issue.
Thanks
Brian
Post #1384833
Welsh Corgi
Welsh Corgi
Posted Thursday, November 15, 2012 7:14 AM
Hall of Fame
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833,
Visits: 4,052
I was not able to resolve the issue.
It is not a permission issue.
I'm ignoring the message.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1385145
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.