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


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 (3)

  1. Janos says:

    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.

  2. Janos says:

    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.

  3. rdouglas66@hotmail.com says:

    Handy to know thanks.