Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 121
  • Last Modified:

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
0
tonyjoewalker
Asked:
tonyjoewalker
  • 3
  • 2
  • 2
3 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Maybe he let some jobs running with his user credentials. Check in SQL Server Agent.
0
 
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
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now