Viewing 15 posts - 36,091 through 36,105 (of 49,552 total)
repent_kog_is_near (10/28/2009)
Thanks for the audio link. You would recommend to start with these basic counters for any server, too?
Absolutely
I asked my SysAdmin and she says that the SAN Storage...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2009 at 8:57 am
You'll need to use triggers to do this.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2009 at 1:14 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic809611-8-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2009 at 3:55 pm
Wow. Just finished a 16 page long performance report. I so hope the client wasn't expecting an 'all-clear' cause it's not.
One more report to do (tomorrow, maybe thursday if all...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2009 at 2:34 pm
There should be more messages than that in the log. Post the entire thing if you're unsure.
Recommendation: As the error message says, restore from backup.
Technical support, in this case, refers...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2009 at 2:26 pm
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2009 at 9:08 am
Jack Corbett (10/27/2009)
Great! Count me for a soda or coffee.
Coffee for me.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2009 at 7:40 am
Viewing 15 posts - 36,091 through 36,105 (of 49,552 total)