Hi, We are attempting to deal with the issue by limiting 'Max Server Memory', initial results have been positive.
https://straightpathsql.com/archives/2017/02/sql-server-max-memory-best-practices/ [https://straightpathsql.com/wp-content/uploads/2017/02/MaxMemory.png]<https://straightpathsql.com/archives/2017/02/sql-server-max-memory-best-practices/> SQL Server Max Memory Best Practices - SQL Server Consulting - Straight Path Solutions<https://straightpathsql.com/archives/2017/02/sql-server-max-memory-best-practices/> In this Straight Up SQL Server Tips series, we’re going back to basics. Many of these are findings in our SQL Server Health Checks or things I bump into on the forums and Q&A sites when I’m out answering questions. Today we’re talking a bit about the SQL Server Memory configuration option – SQL Server Max Memory. straightpathsql.com Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487<tel:402-559-9593> (office) 402-739-3496<tel:402-350-7851> (mobile) ________________________________ From: McNeeley, Todd Alexander <mcneele...@health.missouri.edu> Sent: Tuesday, May 14, 2019 9:03 AM To: Pedersen, Jay G; gpc-dev@listserv.kumc.edu Subject: RE: UNMC, SQL-server based i2b2, special configuration for parallel queries? Non-UNMC email Our main i2b2 is still currently based in KC on Oracle. We have a local one on sql server, but we haven’t started using it as our production i2b2. So it hasn’t been tested to identify the issue you are speaking of. Todd McNeeley Senior Software Engineer, Information Management Team Development mcneele...@health.missouri.edu<mailto:mcneele...@health.missouri.edu> | 573-884-3297 direct | 573-219-8341 mobile Tiger Institute for Health Innovation | www.tiger-institute.org<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.tiger-2Dinstitute.org_&d=DwMGaQ&c=ZukO2fIan9e5E9v43wuy1w&r=zM3QQA6OsIJZ5GcDFWgvZrXix6Wvna2i31M0OeLJSrA&m=FQdHGE-L3-6Xt0Tq-aS7XYmfVNGGQFCm95bYWKKZSqU&s=MyvTVi3edBl7R3Dbmsyxs-ekEAKd9hF6yXttBjRycDg&e=> P PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL From: Gpc-dev <gpc-dev-boun...@listserv.kumc.edu> On Behalf Of Pedersen, Jay G Sent: Monday, May 13, 2019 11:21 PM To: gpc-dev@listserv.kumc.edu Subject: Re: UNMC, SQL-server based i2b2, special configuration for parallel queries? ANy special configuration performed on SQL-Server to make it behave with i2b2 queries? ?? Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487<tel:402-559-9593> (office) 402-739-3496<tel:402-350-7851> (mobile) ________________________________ From: Pedersen, Jay G Sent: Monday, May 13, 2019 7:09 PM To: gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu> Cc: Pedersen, Jay G Subject: UNMC, SQL-server based i2b2, special configuration for parallel queries? Hi, We are starting to run queries against our MS-SQL based i2b2 in Nebraska. We are seeing what seems to be blocking of queries that are trying to be executed in parallel by different users. Does the access to the Fact table by 'active query #1' cause 'active query #2' which also needs to access the Fact table to block? Just wondered if any GPC sites using SQL-Server for i2b2 had run into this, and what they may have done about it. Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487<tel:402-559-9593> (office) 402-739-3496<tel:402-350-7851> (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender.
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev