Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tizona10
Starting Member
1 Post |
 Posted - 2013-02-28 : 16:45:26
|
| In my company we have a application with .NET (C# with LinQ) with SQL Server 2008 R2 and sometimes it lowers its performance and it makes slower of the database. This is more noticeable in some forms than others. Process which typically take seconds to run, with the problem may last 5 minutes. What is most worrying is that in some cases it happens, and another cases, the DB is OK. Sometimes it is solved doing nothing. ¿What can happen?. Until now we are solving rebuilding indexes, reboot SQL Server and even restarting the machine. I've gone mad looking for locks, heavy queries, etc.. but I can't find the solution. What might look to give me hints? What can it be? As I said before, the most unusual is that it doesn't always go wrong. It may be that anything from .NET+LinQ slows the DB?Can anyone to find a solution?Thanks |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-28 : 17:13:31
|
| If the .Net code uses LINQ to SQL, I am not surprised. LINQ to SQL looks elegant when written in C#, but the queries that it sends to the server can be very inefficient.The first thing I would look at is if there are blocking queries - probably the simplest is to run sp_who2. But since you have already done that and found nothing, you may want to look at other things: the load on the CPU, disk activity, memory pressure etc. |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-03-05 : 23:37:00
|
| Using perfmon might give you some thing. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-03-07 : 01:54:43
|
| Is it always the same task or is it different tasks can experience the same problem?If it's always the same tasks - ensure you create some timings for when they run properly. Compare to when running slowly.Drill into the specific sessions nd attempt to identify where the delays is occuring?One other consideration - is there a correlation between increased workload and decreased performance? Are there other activities going on at the same time?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
SQL Server lowers its performance