Viewing 15 posts - 32,071 through 32,085 (of 49,552 total)
Yup, that's the command. Don't run it unless you have the symptoms of the problem (high CMEMTHREAD waits, large token cache). iirc the query to monitor the cache is 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
July 1, 2010 at 9:27 am
No matter what order you specify the columns in the table, in the page the fixed width columns are stored before the variable-length columns.
Try Paul Randal's blog for info. 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
July 1, 2010 at 9:10 am
Oooh... So the way to make Conor blog is to send him questions... I'll start the mail flood... 😀
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
July 1, 2010 at 9:02 am
Did he admit to updating the system objects? Did he give any reason why he did 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
July 1, 2010 at 9:00 am
Check the value of log_reuse_wait_desc in sys.databases. What values (other than NOTHING) do you see for that DB?
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
July 1, 2010 at 8:18 am
virender.singh (7/1/2010)
This should be the easiest question for you all.My question is:
how many records i can insert into a table per second?
It depends.
Depends on hardware, size of table, indexes...
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
July 1, 2010 at 7:38 am
What version of SQL?
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
July 1, 2010 at 7:19 am
Why don't you start a new thread and ask 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
July 1, 2010 at 7:14 am
balasach82 (7/1/2010)
yes, its default trace. But even "select" is not being captured( front end mostly only retrives and less updates)
SELECTs won't be captured in the default trace. The default trace...
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
July 1, 2010 at 6:57 am
Don't suppose you keep a c2 trace or anything similar? Would be interesting to know who SPID 90 was.
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
July 1, 2010 at 6:42 am
Make plans to patch the server
Check the windows event log, make sure that there are no more errors relating to the DBs, to any hardware issues around the time 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
July 1, 2010 at 5:40 am
Possibly because it's full. Shrinkfile just tries to release unused space. If there isn't any unused space, there's nothing to release.
What does DBCC SQLPERF(Logspace) return for this DB?
What is 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
July 1, 2010 at 5:32 am
That is the output.
If there was anything wrong it would have said so in the output window.
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
July 1, 2010 at 5:29 am
There were quite a few nasty bugs in SP2. Consider upgrading to SP3 + the latest hotfix.
Minimal impact from the checkDBs, the system databases are small.
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
July 1, 2010 at 5:14 am
Then rebuild the index. (ALTER INDEX ... REBUILD)
Dropping and recreating the index has at least twice the log impact of just rebuilding the index (SQL has to log the drop,...
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
July 1, 2010 at 5:11 am
Viewing 15 posts - 32,071 through 32,085 (of 49,552 total)