Viewing 15 posts - 40,756 through 40,770 (of 49,552 total)
Bob Hovious (2/25/2009)
Just out of curiousity, how many of you see this forum's ultimate objective to be giving people fish, or teaching them to fish?
Teaching, but you can't teach someone...
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
February 25, 2009 at 11:26 am
sudhakara (2/25/2009)
How do you exactly calculate the average disk queue in performon ?
If you have a SAN, don't bother. That counter's near impossible to interpret properly when the 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
February 25, 2009 at 11:22 am
Since it's 2000, to get the exec plan, run the query with the statement SET STATISTICS PROFILE ON above it.
There will be a second resultset. Copy that, paste in excel,...
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
February 25, 2009 at 11:20 am
steve smith (2/25/2009)
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
February 25, 2009 at 10:08 am
steve smith (2/25/2009)
Sorry all. This is the first time that I've experimented with using font sizing. Does '2' work better? [pls reply only if you need larger]
How...
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
February 25, 2009 at 9:41 am
Steve Jones - Editor (2/25/2009)
Job - granularity is only every minute, so be aware there.
The job doesn't have to be scheduled. I did something like this with replication where 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
February 25, 2009 at 9:16 am
What kind of system is this? What data are you storing?
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
February 25, 2009 at 9:14 am
Lynn Pettis (2/25/2009)
What is "best practices" actually? What is "best" today may not be "best" a week, or month, or year from now.
Which is one of the reasons I...
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
February 25, 2009 at 9:10 am
Also Inside SQL Server 2005: Query Tuning and Optimisation which, as it's name implies, is an entire book on query tuning and optimisation.
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
February 25, 2009 at 9:07 am
It's perfectly normal with 2000 SP4. It happened in earlier versions, but wasn't reported.
If a query runs parallel and some of the threads are slower than others, the ones that...
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
February 25, 2009 at 9:02 am
DBA (2/25/2009)
should'nt the DBCC OPENTRAN returnthis open transaction?
What DB are you running it in? What DB's the transaction in?
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
February 25, 2009 at 8:53 am
steve smith (2/25/2009)
Snapshot processes will not pick up new views.
Depends what you mean by snapshot.
Full database backups, at least for SS 2005, will backup the full...
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
February 25, 2009 at 8:53 am
I'd go for job or service broker.
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
February 25, 2009 at 8:51 am
srisagar_p (2/24/2009)
so deadlock occurrence is also high for me. Every time time i need to kill if a deadlock occurs through Kill command
Are you talking about blocking or deadlocks?...
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
February 25, 2009 at 12:30 am
What's the blocking resource?
Can you show some of the code?
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
February 25, 2009 at 12:30 am
Viewing 15 posts - 40,756 through 40,770 (of 49,552 total)