{"action":"created","issue":{"url":"https://api.github.com/repos/Microsoft/sqlopsstudio/issues/2592","repository_url":"https://api.github.com/repos/Microsoft/sqlopsstudio","labels_url":"https://api.github.com/repos/Microsoft/sqlopsstudio/issues/2592/labels{/name}","comments_url":"https://api.github.com/repos/Microsoft/sqlopsstudio/issues/2592/comments","events_url":"https://api.github.com/repos/Microsoft/sqlopsstudio/issues/2592/events","html_url":"https://github.com/Microsoft/sqlopsstudio/issues/2592","id":360417024,"node_id":"MDU6SXNzdWUzNjA0MTcwMjQ=","number":2592,"title":"Ops studio becomes unresponsive after a query returns many result sets over many hours","user":{"login":"MattIrv","id":3758704,"node_id":"MDQ6VXNlcjM3NTg3MDQ=","avatar_url":"https://avatars3.githubusercontent.com/u/3758704?v=4","gravatar_id":"","url":"https://api.github.com/users/MattIrv","html_url":"https://github.com/MattIrv","followers_url":"https://api.github.com/users/MattIrv/followers","following_url":"https://api.github.com/users/MattIrv/following{/other_user}","gists_url":"https://api.github.com/users/MattIrv/gists{/gist_id}","starred_url":"https://api.github.com/users/MattIrv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MattIrv/subscriptions","organizations_url":"https://api.github.com/users/MattIrv/orgs","repos_url":"https://api.github.com/users/MattIrv/repos","events_url":"https://api.github.com/users/MattIrv/events{/privacy}","received_events_url":"https://api.github.com/users/MattIrv/received_events","type":"User","site_admin":false},"labels":[{"id":738071861,"node_id":"MDU6TGFiZWw3MzgwNzE4NjE=","url":"https://api.github.com/repos/Microsoft/sqlopsstudio/labels/bug","name":"bug","color":"ee0701","default":true},{"id":757029991,"node_id":"MDU6TGFiZWw3NTcwMjk5OTE=","url":"https://api.github.com/repos/Microsoft/sqlopsstudio/labels/query%20execution","name":"query execution","color":"f98d68","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-09-14T18:55:23Z","updated_at":"2018-09-14T19:49:18Z","closed_at":null,"author_association":"MEMBER","body":"- SQL Operations Studio Version: master\r\n\r\nSteps to Reproduce:\r\n1. Run a query that returns, for example, 1 result set with 1000 rows every minute\r\n2. Let this query run for a long time (I did it for ~24 hours)\r\n\r\nAt the end of the 24 hours Ops Studio is unresponsive.\r\n\r\nIt's probably reasonable to have some upper limit on what we can handle and this might be past it, but since our code is supposed to window results @ranasaria and I were a bit surprised to see this happen so we should at least investigate it\r\n"},"comment":{"url":"https://api.github.com/repos/Microsoft/sqlopsstudio/issues/comments/421466158","html_url":"https://github.com/Microsoft/sqlopsstudio/issues/2592#issuecomment-421466158","issue_url":"https://api.github.com/repos/Microsoft/sqlopsstudio/issues/2592","id":421466158,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMTQ2NjE1OA==","user":{"login":"ranasaria","id":41588310,"node_id":"MDQ6VXNlcjQxNTg4MzEw","avatar_url":"https://avatars2.githubusercontent.com/u/41588310?v=4","gravatar_id":"","url":"https://api.github.com/users/ranasaria","html_url":"https://github.com/ranasaria","followers_url":"https://api.github.com/users/ranasaria/followers","following_url":"https://api.github.com/users/ranasaria/following{/other_user}","gists_url":"https://api.github.com/users/ranasaria/gists{/gist_id}","starred_url":"https://api.github.com/users/ranasaria/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ranasaria/subscriptions","organizations_url":"https://api.github.com/users/ranasaria/orgs","repos_url":"https://api.github.com/users/ranasaria/repos","events_url":"https://api.github.com/users/ranasaria/events{/privacy}","received_events_url":"https://api.github.com/users/ranasaria/received_events","type":"User","site_admin":false},"created_at":"2018-09-14T19:49:18Z","updated_at":"2018-09-14T19:49:18Z","author_association":"CONTRIBUTOR","body":"Yeah, the fix we will need to do is to window the number of resultsets as well. Or window total number of rows displayed across all result sets.\n\n\n-  Arvind.\n\n________________________________\nFrom: Anthony Dresser <notifications@github.com>\nSent: Friday, September 14, 2018 12:47:56 PM\nTo: Microsoft/sqlopsstudio\nCc: Arvind Ranasaria; Mention\nSubject: Re: [Microsoft/sqlopsstudio] Ops studio becomes unresponsive after a query returns many result sets over many hours (#2592)\n\n\nWe window each result set but we don't window all the results sets. I.E if there are 100 results sets and we window 50 rows from each we have 5000 (50*100) rows in memory.\n\n—\nYou are receiving this because you were mentioned.\nReply to this email directly, view it on GitHub<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsqlopsstudio%2Fissues%2F2592%23issuecomment-421465817&data=02%7C01%7CArvind.Ranasaria%40microsoft.com%7Cf71d62d6c758442a367608d61a7af819%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636725512785476807&sdata=7%2BJq9jZvewx5oDti0CwFW0b0rDdDEPmZ%2FayzAOu0Xak%3D&reserved=0>, or mute the thread<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAnqWVsYi7PxwWWlfzkf8y4PZee2AkL99ks5ubAfsgaJpZM4Wpxx0&data=02%7C01%7CArvind.Ranasaria%40microsoft.com%7Cf71d62d6c758442a367608d61a7af819%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636725512785486815&sdata=mCRNgQl%2BcBV%2BG%2F00xP6hnQdkad%2F0SGzslc4opay4MuU%3D&reserved=0>.\n"}}
{"actor":{"display_login":"ranasaria"}}