SQL server performance-- memory / I/Ocaching

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL server performance-- memory / I/Ocaching

SQL server performance-- memory / I/Ocaching

Rate Topic

Display Mode

Topic Options

Author

Message

tauseef.jan

Posted Monday, September 24, 2012 8:52 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 7:57 AM
Points: 13, Visits: 120

hello nerds,

I have a request.. Can anyone help me in getting the
large queries being run on sql server by users that return an excessive number of rows.

Your help is appreciated .

T

Post #1363549

GilaMonster

Posted Monday, September 24, 2012 9:05 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:12 PM
Points: 38,062, Visits: 30,355

Nerds????

Very hard to get the queries that return lots of rows. Getting ones that do huge numbers of reads is easier. Try
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1363556

Grant Fritchey

Posted Monday, September 24, 2012 11:06 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 13,436, Visits: 25,281

If very large data sets are needed, there's seldom much tuning that can be done through T-SQL or indexes. Usually, if you have to move extremely large data sets, you need to tune the hardware, or, in other words, throw money at the problem.

But that's just a general view on your open-ended question. Do you have a specific issue you're trying to solve?

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1363635

Posted Monday, September 24, 2012 9:43 PM

Old Hand

Group: General Forum Members
Last Login: Today @ 5:07 AM
Points: 327, Visits: 532

select row_count , C.Text From sys.dm_exec_sessions ES ,sys.dm_exec_connections EC
Cross apply sys.dm_exec_sql_text (Ec.most_recent_sql_handle) C
where Es.session_id= EC.session_id

Not sure why you try to find out number of result sets. But above query can guide you.

Post #1363767

« Prev Topic | Next Topic »

Permissions