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

SQL server performance-- memory / I/Ocaching Expand / Collapse
Author
Message
Posted Monday, September 24, 2012 8:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 1:27 PM
Points: 13, Visits: 131
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
Posted Monday, September 24, 2012 9:05 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:35 PM
Points: 40,438, Visits: 36,895
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
Posted Monday, September 24, 2012 11:06 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 14,034, Visits: 28,406
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 Query Performance Tuning
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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
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 »

Add to briefcase

Permissions Expand / Collapse