SQL2012 .Net SqlClient Data Provider

Hi

I have a 2 server SQL cluster that my coworker installed and the tool Embarcadero DBAritisan is showing 30 or so processes of .Net SqlClient Data Provider running under my coworkers ID.  Other SQL2012 clusters that I've installed don't have this process showing up in the DBAritisan tool.

I'm not a SQL person and a DBA brought this to my attention.  The DBA has looked over SQL and I've looked over Windows 2008 R2 and Failover Cluster properties and we can't figure out why this install has this process running 30 times with my coworkers user ID.

Is there something in the SQL2012 install that he might have done differently?  It is using too much CPU and memory and the DBA would like this removed.

Any Ideas?

Thank you.

Tony
tonyjoewalkerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Maybe he let some jobs running with his user credentials. Check in SQL Server Agent.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tonyjoewalkerAuthor Commented:
That is a good thought!  Our DBA checked that out and didn't find any jobs in SQL server agent running under my coworkers ID.

Any other ideas?

Thank you.

Tony
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Running a SQL Profiler to capture the origin of the running processes.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Vadim RappCommented:
The DBA also should be able to tell (1) the workstation this came from, to make sure it's from the same place, and more important, (2) specific SQL statement that runs. Knowing sql statement, you will be able to narrow down.
0
Vadim RappCommented:
split between

http:#a40319393
http:#a40319493

which are general troubleshooting steps everybody always does in situations like this one.
0
tonyjoewalkerAuthor Commented:
everything is great.  please close this.
0
tonyjoewalkerAuthor Commented:
everything is great. I got the information I need.  thank you for the comments, the issue has resolved itself.  please delete question..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.