Share via

How It Works: XEL Display in SQL Server Management Studio (SSMS) Row Limit

  • Article

This is a simple issue but if you don't expect the behavior it can surprise you.

The grid, used by SSMS, is limited to a maximum number of rows, that can be displayed, of 1 million.   

Note: There is no warning dialog or flashing toolbar.

Shown in the figure below is the display vs event totals.

clip_image001

The design is an internal, display filter always including TOP 1000000.   

You may adjust other filter criteria, such as the time rage, event type, and up to the first 1 million rows meeting the filter criteria are displayed.

Bob Dorr - Principal SQL Server Escalation Engineer

Comments

  • Anonymous
    August 06, 2012
    Copy/Paste does not work properly neither. Some of the rows are missing when I'm trying to copy a "bigger" result set from the grid view. When I set the results to file, I got all rows. I have got the same behavior with SSMS 2008 as well.

  • Anonymous
    August 06, 2012
    Copy/Paste does not work properly neither. Some of the rows are missing when I'm trying to copy a "bigger" result set from the grid view. When I set the results to file, I got all rows. I have got the same behavior with SSMS 2008 as well.

  • Anonymous
    September 05, 2012
    Handy to know thanks.