212 reputation
28
bio website
location Baton Rouge, LA
age 30
visits member for 3 years, 2 months
seen Dec 12 at 22:19

I'll have a dash of C++ on my C, please!


Sep
24
awarded  Autobiographer
Jul
2
awarded  Curious
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