Viewing 15 posts - 22,591 through 22,605 (of 49,552 total)
MasterDB (11/1/2011)
After setting Max server memory to 28 GB still in the Task manager PFusage is showing as 29.7GB.
Task manager = pile of lies. Plus what it shows and what...
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
November 1, 2011 at 8:21 am
MasterDB (11/1/2011)
Ninja:i set max server memory for SQL is 40722MB
So you've told SQL Server to use 40GB out of the available 32 GB. See the problem with 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
November 1, 2011 at 8:19 am
If you post what I asked for, maybe we can give you some suggestions.
GilaMonster (11/1/2011)
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
November 1, 2011 at 8:18 am
How much memory total on the server?
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
November 1, 2011 at 5:02 am
I would suggest you enable optimise for ad-hoc workloads. Plan guides are not an answer to this kind of problem, unless they're parameterisation ones.
Edit: hang on... nHibernate by any chance?
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
November 1, 2011 at 5:01 am
dm_tapas (11/1/2011)
Please copy it to your SSMS and try to tune it . (SQL SERVER 2005)
How much are you paying me to tune it? That's easily a day of work...
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
November 1, 2011 at 4:59 am
Oh, and for transactions and error handling, have a look at this: http://sqlinthewild.co.za/index.php/2011/05/17/on-transactions-errors-and-rollbacks/
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
November 1, 2011 at 4:55 am
Suitable for your code, that only you can decide. Best - none of them. They all have advantages and disadvantages, you should understand them and be able to decide 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
November 1, 2011 at 4:52 am
You have no transaction in that code, and no error handling. Every statement runs independently and can succeed or fail by itself.
Read up on transactions, Try.. catch and isolation levels
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
November 1, 2011 at 3:08 am
BaldNomad (10/31/2011)
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
November 1, 2011 at 3:00 am
BaldNomad (10/31/2011)
Question is, am I likely to fix this deadlock by removing the select statement from this procedure?
Very likely.
It's trying to convert an S lock (which the select would take)...
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 31, 2011 at 4:32 pm
anthony.green (10/31/2011)
I have always been told to try and get a cluster which best suits the business, but I take your expert advise, many thanks.
There are 2 main schools 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 31, 2011 at 3:27 pm
Query sys.dm_db_index_physical_stats. Limited mode is good enough. See the page_count column
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 31, 2011 at 2:41 pm
Ninja's_RGR'us (10/31/2011)
Tx Gail, 100 MB is still a tiny trace on a busy server... but it's better than 25 mb :hehe:
Bear in mind that not much is traced, DDL, security...
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 31, 2011 at 2:11 pm
Ninja's_RGR'us (10/31/2011)
This of course assumes that over those few weeks, the trace didn't rollover and delete that info (only 25 mb logged IIRC).
5 files of 20MB each.
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 31, 2011 at 2:01 pm
Viewing 15 posts - 22,591 through 22,605 (of 49,552 total)