Viewing 15 posts - 1 through 15 (of 20 total)
So it turns out that the system we were running this on utilizes a strong password filter library (http://msdn.microsoft.com/en-us/library/windows/desktop/ms721766(v=vs.85).aspx) and that for whatever reason we believe the password...
September 5, 2013 at 10:15 am
The sql you posted is a view, could you post the SQL from the view? What happens if you run the same sql that the view uses to get the...
July 7, 2011 at 11:21 am
We had something similar happen, two weeks in a row. Question can you link the time it at which it reinitializes to an event that was x hours prior where...
July 6, 2011 at 9:17 pm
It's always good to see these threads come together and a solution come to light. I am very curious now, on your old server how were you not seeing these...
July 5, 2011 at 4:34 pm
The newPlan you attached still has a degree of parallelism of 24. That is still going to hurt the performance of your server. Can you post the plan for the...
July 5, 2011 at 10:56 am
Why don't you use sysmd.os_wait_stats to look at the stats since the instance was restarted. Maybe grab the results from running it in the morning perhaps before usage picks up...
July 3, 2011 at 4:52 pm
I noticed a few issues that I cleaned up in what I posted. You didn't close your print statements correctly, the IF statement was incorrect, and because this is running...
June 20, 2011 at 9:53 am
I agree with Jeff. Post up a sample of your trigger and your requirements and maybe we could help you more.
June 17, 2011 at 7:24 am
What about something like the below? Create a trigger at the server level that creates a trigger on the new database. Your trigger definition that would go on the user...
June 15, 2011 at 7:05 pm
Yeah that is basically what I recommended, at least the heavier usage clients should be moved into their own instance. That is just not what accounting wants to hear...
June 13, 2011 at 12:55 pm
What about the case were you have multiple client databases on a single instance. You may have one client database and their queries that is overusing the CPU and starving...
June 13, 2011 at 12:35 pm
Grant, thanks for the reply! I've got your blog in my Google reader and love it and I am reading SQL Server 2008 Query Performance Tuning Distilled.
Yeah I think something...
May 20, 2011 at 11:30 am
Looks like we've got it. It was a mixture of reducing the Virtual Log Files and changing a few of the heavy lifting SPUs to replicate the execution as well.
April 12, 2011 at 2:01 pm
I think we have slowly started to resolve the issue. Reducing the # of VLF has helped a lot! We then noticed the sheer # of commands was high. We...
April 7, 2011 at 9:17 am
Jimbo, you sending me down the route of looking into VLF I came across by Linchi Shea about VLF and performance with high number vs lower number of VLF. I...
March 28, 2011 at 3:21 pm