Viewing 15 posts - 46 through 60 (of 151 total)
Sweet!
Now go into perfmon and open up the SQL Server: Databases performance object. Throw in Transactions/sec for tempdb, and then _total (for all databases of course), and divide up to...
April 7, 2009 at 2:00 pm
This is a good counter, but again, you need to look at others as well. Did you divide the number of disks by your value to get the true queue...
March 30, 2009 at 8:12 am
No I don't think anywhere near that full size. Try 15% of total and you should be ok. If it grows, extend out a bit. Leave it on auto grow....
March 24, 2009 at 12:08 pm
Oh sorry. It's the Replay Markup Utilities for SQL Server. It's the PSS diag written by Ken Henderson but most up to date version, more or less. It can look...
March 21, 2009 at 8:23 pm
So, what you seemed to indicate is that on SQL Server 2000 it is possible to replicate between a (write) master and a (read) slave(s?), but not between masters?
First,...
March 21, 2009 at 1:02 pm
Not sure what the 'old hand' is specifically referring to, but SQL Server does not support "shared nothing" type architectures. (I say this, but there is an initiative that is...
March 21, 2009 at 10:04 am
LOL no worries! I've hit that thing too. Thanks to Microsoft for putting it right next to Execute.
March 21, 2009 at 9:46 am
Sounds like a good one to trace using sql trace procs or profiler. Put results into a table, or better yet, use RML to view what's happening.
March 21, 2009 at 9:43 am
Sounds to me that he's simply pushing off the aggregation to a derived table. But he'd still have to do the SUM there right?
March 21, 2009 at 9:40 am
I"ve never had a problem with any Red Gate product and FKs. If you script out it's code first, you can see that it uses what it needs to handle...
March 21, 2009 at 9:26 am
His answer is actually wrong. If you have an "HoursWorked" attribute, you have to assume that this is a roll-up of all hours for the employee since he/she has been...
March 21, 2009 at 9:23 am
Great suggestion Grant. That's what I'd do - simply default the value in the proc to something and then bypass it with the value sent. Param sniffing has been greatly...
March 21, 2009 at 8:34 am
I say it needs more RAM, but that's not necessarily the case. Use many counters and tests to conclude this, not just one. Sorry.
Ok - so your page life is...
March 20, 2009 at 10:42 am
Viewing 15 posts - 46 through 60 (of 151 total)