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 |
|
jmhorrell
Starting Member
1 Post |
 Posted - 2014-06-20 : 10:31:59
|
| SQL 2008 R2. When i examine SQL Server Profiler i am seeing about 90 activities per second. all of which look like: exec sp_execute or declare @p1... or even exec sp_undeclare. These seem to be programatically generated or scripted. it is really bogging down my server. Not a SQL expert, but i can check\do anything you need.John Horrell |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-06-20 : 10:47:29
|
| if you're running the Standard(defaul) trace , you'll see all the steps. If you're experiencing a slow down of the SQL Server, checkout : sql server error logs, event logs, and check out the current queries - looking for any excessive blocking and any other hints that will allow you to dig deeper into finding a solutio - http://www.sqlserver-dba.com/2012/09/sql-server-current-queries-executing-on-sql-server.htmlAre you maintaining the databases proactively - such as regular maintenance scripts for indices . Have any code releases occured recently?Has the workload increased?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
SQL Server Overload - Please Help