0
votes
0answers
13 views

Log ODBC queries including execution times to solve performance issue

We are facing some Perdormance issue in out web aplication which uses an ODBC Connection, i would like to log running queries to analyse where the problem is, Is there any way to make ODBC log the ...
0
votes
1answer
211 views

dm_exec_query_stats returns worker time greater than elapsed time

I frequently query sys.dm_exec_query_stats to find expensive queries. I've noticed that in some cases the total_worker_time is greater than the total_elapsed_time. Does anyone know why this would be ...
1
vote
4answers
1k views

High CXPACKET wait type in SQL Server even with MAXDOP = 1

I have always had a very high CXPACKET wait type, and I've been told that it stems from parallel processing, and I should keep MAXIMUM DEGREE OF PARALLELISM = (NÂș Processors / 4), or 1 in my case. ...
1
vote
2answers
161 views

SQL performance, how to exactly measure bottlenecks

Yesterday me (programmer) and one of my coworkers from our Hosting department started series of tests to address performance issues with our websites. We are running a server with Windows Server 2008 ...
0
votes
2answers
153 views

What to seek/avoid in a hosted server monitoring service?

I'm looking for hosted monitoring solution (CPU, memory, disk, loads, mysql, replication network etc..) for a group of servers on Amazon EC2 /Scalr (app, mysql, load balancer). So far I found ...