Viewing 15 posts - 35,356 through 35,370 (of 49,552 total)
wimark (12/10/2009)
What does '...shared locks are released as soon as the statement is complete...' mean exactly?
Locks are released when they are no longer needed, is once the row/page/table has been...
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
December 10, 2009 at 10:53 am
What's the read and write stall look like for 24 hours?
What's the % idle time, avg sec/read and avg sec/write for the log drive? For the data drive? (perfmon)
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
December 10, 2009 at 10:39 am
Krasavita (12/10/2009)
I already have AWE check and I have Standard Edition.
If you have Standard edition of SQL 2000 then this entire conversation has been completely, 100%, totally useless.
Standard edition 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
December 10, 2009 at 10:37 am
Krasavita (12/10/2009)
I still would like to know if I check this option to true Lock pages in memory will this increase a perfomance?
Not necessarily. All it's going to do...
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
December 10, 2009 at 9:58 am
Does anything perhaps insert mostly blank rows then come back and update them? Or do an update to null and then an update with the actual values? It's something I've...
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
December 10, 2009 at 9:51 am
Grant Fritchey (12/10/2009)
I'd love to come down & visit. No time soon though. Flights to Orlando are cheap. Flights to SA, not so much.
Yeah, don't remind me. I'm looking at...
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
December 10, 2009 at 9:41 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
December 10, 2009 at 9:15 am
If your log is backing up 1 GB every hour, that's probably accounting for the majority of those 19GB.
Why are you so focused on the log writes? Are you seeing...
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
December 10, 2009 at 9:06 am
Would you mind posting the entire definition of the proc, not just the updates that are involved in the deadlock. I'd like to see the data types of the parameters,...
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
December 10, 2009 at 9:02 am
I would start with 0.25 files/core, all on the same drive then, if there is allocation contention, add more files, if there is IO contention move the files onto separate...
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
December 10, 2009 at 6:01 am
Can you post the code for the procedure dbo.spi__print_release and the structure (with indexes) of the table dbo.printing_header.
btw, you can switch traceflag 1204 off. On SQL 2005, 1222 prints 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
December 10, 2009 at 5:53 am
Grant Fritchey (12/10/2009)
Jack Corbett (12/9/2009)
OPASS stands for Orlando PASS and, yes, that would be Florida with Disney and all that. It was 80's today and we have the AC...
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
December 10, 2009 at 5:45 am
Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
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
December 10, 2009 at 2:22 am
In a clustered SQL Server, all DBs must be on shared drives that have been set up as resources in the cluster and set as dependencies of the SQL Service.
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
December 10, 2009 at 2:06 am
Other than getting lots more waits, the mechanism for monitoring hasn't really changed. It's sys.dm_os_wait_stats (for the cumulative ones), sys.dm_os_waiting_tasks for the current waits.
There are quite a few waits 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
December 10, 2009 at 2:03 am
Viewing 15 posts - 35,356 through 35,370 (of 49,552 total)