Try removing the
CONVERT
. Do that conversion in your presentation layer.
Doing something similar with
IsActive
will probably help too.
As an aside, try to avoid using reserved words for column or table names. If you must use them then surround them with square brackets.
select ID, ErrorDescription, ErrorPage, IpAddress,
PageEvent, [Status], CreatedDate,
[Status] as IsActive from dbo.ExceptionLog order by ID desc
Check to see if there are any indexes on this table - on ID at the very least.