meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | 29 | |
| visits | member for | 1 year, 7 months |
| seen | Jul 30 '12 at 16:41 | |
| stats | profile views | 8 |
I'll have a dash of C++ on my C, please!
|
Oct 6 |
awarded | Yearling |
|
Jun 8 |
awarded | Constituent |
|
Jun 8 |
awarded | Caucus |
|
May 11 |
comment |
Optimization around static cursor use Thank you for the thoughts. I've tried tweaking CURSOR_THRESHOLD with no gains (and as expected a few slowdowns), and moving tempdb into a RAM disk didn't help (the server has plenty of free memory, so so decreasing SQL Server's cache space isn't an issue). As for plan guides, I'm going to have to spend a bit of time with that to test it, but at this point optimizing the plans isn't really the issue -- good execution strategies are taken, but copying the entire result set is the bottle neck (AFAICT). |
|
May 11 |
revised |
Optimization around static cursor use added 306 characters in body |
|
May 11 |
comment |
Optimization around static cursor use @SqlACID: SQL Server seems to be swimming in memory (it's not a large DB), so to test the SSD idea I instead created a RAMDisk and moved tempdb there. Unfortunately, there's no measurable performance increase. |
|
May 11 |
comment |
Optimization around static cursor use @SqlACID: That's not a bad idea, although this computer has no shortage of RAM. That being the case, would tempdb be doing that much disk IO? (Although I suppose any IO slowdown is a disaster with this many cursors. And I suppose I could measure this, I just need to figure out how.) Also, can tempdb be thrown into a RAM disk? |
|
May 11 |
revised |
Optimization around static cursor use added 141 characters in body |
|
May 10 |
comment |
Optimization around static cursor use Not a bad conclusion. Also not an option I can currently exercise, not for lack of trying. |
|
May 10 |
asked | Optimization around static cursor use |
|
Mar 23 |
comment |
Send a trigger to an application upon a specific SQL Server server usage pattern It's a very, very old program written in C or C++ and goes through Visual Data Flex for DB access. It is still maintained and they have a regular release schedule, so it's not out of date software -- it just comes from old origins. |
|
Mar 23 |
comment |
Send a trigger to an application upon a specific SQL Server server usage pattern Hm.. Although I can't help but wonder if QNs can be used on management objects. |
|
Mar 23 |
comment |
Send a trigger to an application upon a specific SQL Server server usage pattern I've taken a look at Query Notifications, and from what I've been able to tell thus far it only triggers when something has changed. In my case, there are no data changes -- just look-ups. |
|
Mar 23 |
awarded | Commentator |
|
Mar 23 |
comment |
Send a trigger to an application upon a specific SQL Server server usage pattern @Joshua: That looks pretty handy, however if there a way to trigger that when a request is issued? The queries I'm trying to catch aren't long ongoing queries. |
|
Jan 19 |
revised |
Send a trigger to an application upon a specific SQL Server server usage pattern added 109 characters in body; edited tags; edited title |
|
Jan 18 |
comment |
Send a trigger to an application upon a specific SQL Server server usage pattern I have other ways of dealing with this. While capturing an IP or something sufficiently "unique" for my particular circumstance would be ideal, it's also sufficient for me to only allow one client to view a subset of data at a time. |
|
Jan 18 |
asked | Send a trigger to an application upon a specific SQL Server server usage pattern |
|
Dec 20 |
comment |
On-the-fly query/command modification I truly dislike this answer, but it's the correct one. I come from a world of software development where I can fix problems with my own technical expertise which other parties refuse to. I'm now placed in a world where I cannot, and it's been a grating experience in some respects. |
|
Dec 20 |
accepted | On-the-fly query/command modification |
