Memory consumption while executing the Query RRS feed

  • Question

  • Hi Team,

    We have developed a .Net WPF application which is using ADO.Net to read data from the SQL server. As part of the WPF application, a query returns 20,00,000 records. At this time application is consuming more than 5 GB memory. Whereas if we run the same query from SQL Management Studio (SSMS), it takes a very less memory (i.e 40 MB).

    Since we are loading the same data (from same query) from both applications (SSMS and WPF application), we want to know why the SSMS is taking very less memory and WPF .Net application takes huge memory.

    Please help me fix the memory issue in our WPF application while executing the query. Thanks.

    Thanks & Regards
    Naga Suresh D

    Monday, November 18, 2019 3:40 PM

All replies