memory leaks - geometry::UnionAggregate call causes SQL Server to crash -

-

i found seems bug in microsoft sql server (v13.0.1601). perhaps mistaken haven't seen reported anywhere else online describe below.

one section of our code uses spatial indexing. have table called 'spritepositions' contains polygons , 'sprite' table, each entry of links number of spritepositions. each sprite has polygon populated using geometry::unionaggregate call, combining each of polygons of appropriate spritepositions.

rarely, sprite may contain large number of spritepositions , unionaggregate call takes little while complete. interestingly, time not linearly proportionate number of spriteposition polygons.

some experiments indicate performing unionaggregate takes around 4 seconds 500 polygons, around 20 seconds 1000 polygons. 10000 polygons sql server this:

memory leak in sql server

looks memory leak in sqlserver. never returns - ram usage keeps growing forever , cpu usage sits @ 1 full core. no further sql calls return , solution kill sql server process.

so question - has else encountered this? there i'm missing?


Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more