Viewing 15 posts - 36,106 through 36,120 (of 49,562 total)
Jeffrey Williams-493691 (10/27/2009)
Before using the with init option to initialize an existing file - you really need to make sure that backup has been copied to offline storage.
Indeed. In fact,...
October 27, 2009 at 1:03 pm
repent_kog_is_near (10/27/2009)
the users are complaining of slow reads in the reporting.
Then consider trying to optimise the offending queries, rather than looking at the hardware. If the queries are non-optimal, it's...
October 27, 2009 at 11:51 am
David Benoit (10/27/2009)
The reason for my response was that his average was over an extended period of time.
And it could well have been that there were a couple of...
October 27, 2009 at 11:44 am
GLIC DBA (10/27/2009)
Just one question, did you mean to say "physical" instead of "logical" in the following statement? Clustered indexes define the logical order of the table.
No....
October 27, 2009 at 11:35 am
David Benoit (10/27/2009)
That appears to be a pretty high disk queue length to me. 🙂
<shrug> Two points
SQL is designed to drive the disk queue up. It's not unusual to have...
October 27, 2009 at 11:19 am
The sec/transfer looks a little high. Don't see any other problems at a quick glance
Do you have a performance problem or are you setting up a baseline for the system?
High...
October 27, 2009 at 10:08 am
fred2002 (10/27/2009)
to Set the current size to a large value is a limit.
To set the current size to a large size is to just set the current file size. Nothing...
October 27, 2009 at 9:29 am
Not surprised. From experience badly-written SQL will max the processors out but once the code's optimised the disks are usually the bottleneck.
October 27, 2009 at 9:27 am
Sorry, but I don't see anywhere where they say to limit the max size.
Under the section "Prevent the transaction log files from growing unexpectedly" there's
Set the current size to a...
October 27, 2009 at 9:08 am
Jack Corbett (10/27/2009)
Great! Count me for a soda or coffee.
Coffee for me.
October 27, 2009 at 7:40 am
Bob Hovious 24601 (10/27/2009)
Grant, I'm a poor substitute for Jeff, but I'd be happy to have a drink with you next week. I'll even buy the first round.
I...
October 27, 2009 at 7:29 am
Jeff Moden (10/26/2009)
October 27, 2009 at 7:23 am
It's very hard to max out all of the CPUs on modern multi-proc machines. Very few workloads are limited by CPU bottlenecks. Far more common are memory/disk. It's very likely...
October 27, 2009 at 7:23 am
Tara-1044200 (10/27/2009)
I assume when this is executed it has to delete the existign backup and do fresh copy of backup but it i think it is not deleting the existing...
October 27, 2009 at 7:18 am
Viewing 15 posts - 36,106 through 36,120 (of 49,562 total)