Viewing 15 posts - 48,391 through 48,405 (of 49,552 total)
K. Brian Kelley (10/4/2007)
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 4, 2007 at 7:45 am
Anders Pedersen (10/4/2007)
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 4, 2007 at 7:36 am
If you can, run the SQLIOSim (of SQLIOStress, can't remember the name) and see what it tells you about the drives.
It's a stress test tool for drives that simulated the...
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 4, 2007 at 7:07 am
Not at the time, 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 4, 2007 at 6:52 am
I've also seen it in those circumstances, but it's fairly unlikely here. 11pm is the beginning of the overnight process run, and there should be no more than 30-50 connections...
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 4, 2007 at 6:29 am
If you're working on SQL 2000, please rather post in the SQL 2000 forums. If you post in SQL 2005 forums, people will offer 2005-specific solutions.
I'm not understanding your problem....
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 4, 2007 at 6:28 am
In my experience, buffer latch timeouts are often IO related. You may want to check you drive's performance if you get these more than once or twice.
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 4, 2007 at 1:43 am
Since you're working with SQL 2005 (or I assume so, based on the forum) don't use text. It's deprecated. Rather use the varchar(max) datatype.
Also, what you're doing is very strange....
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 4, 2007 at 12:15 am
Nick Via (10/3/2007)
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 3, 2007 at 9:48 am
Yup 🙂 That'll give you the names of any triggers on the table. Once you have the names, you can use sp_helptext to get the text of the...
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 3, 2007 at 9:38 am
Any strange messages in the sql error log? any strange messages in the windows event log?
What's the specs of the server? (memory, cpus)
Have you tried connecting via the DAC when...
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 3, 2007 at 9:19 am
Wapper (10/3/2007)
GilaMonster, I cannot use convering index because next_id and status are only used for finding records, but to display what I've found I need all fields.
You might still be...
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 3, 2007 at 6:17 am
First, a big, big thank you to Lara Rubbelke from Microsoft who presented on this at PASS recently. This code is derived from her presentation, and not somethng I came...
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 3, 2007 at 5:49 am
Ok, now that the crises are out of the way and I have a couple free minutes, let em see what I can conjure up for you.
This is going to...
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 3, 2007 at 4:43 am
I joined SQL Central about 5 years ago, intitially as a place to get answers to problems I had with SQL. At the time I was just starting out on...
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 3, 2007 at 4:31 am
Viewing 15 posts - 48,391 through 48,405 (of 49,552 total)