Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

performance tuning scenario Expand / Collapse
Author
Message
Posted Saturday, January 5, 2008 11:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, January 12, 2008 1:54 PM
Points: 3, Visits: 8
Hi All,

I am in need off potential triggering point of SQL server performance.
In my case i am looking for which are or may not be fairly visible within SQL Server framework as an indicator by means of DBA running a SQL and trying to find what is going with such perforamance issue.

in a retrospect what are basic issue which can be alerted to DBA and avoid some particular task as addition to DBA as a utility.

Thanks
Post #439313
Posted Sunday, January 6, 2008 9:57 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 2:13 PM
Points: 31,040, Visits: 15,472
There is no set thing to look for. Is there a problem with your server?

Usually you check if things are slow. If you want to generally tune everything, start by running Profiler, seeing what's run often, and then try to speed it up.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #439350
Posted Sunday, January 6, 2008 10:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, January 12, 2008 1:54 PM
Points: 3, Visits: 8
Hi Steve,
Thanks for reply.

I am working on my MS project for performance tuning agents.
I need SQL server use cases in which I can find problem with sql queries then compare with acceptable thresholds and then agent suggest changes(query to make changes).

Thanks in advance :)

Post #439355
Posted Tuesday, January 8, 2008 11:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, January 12, 2008 1:54 PM
Points: 3, Visits: 8
can anybody help me?

Thanks.
Post #440428
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse