Viewing 15 posts - 9,121 through 9,135 (of 49,552 total)
TheSQLGuru (5/7/2014)
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
May 7, 2014 at 12:17 pm
Grant Fritchey (5/7/2014)
jcrawf02 (5/7/2014)
ChrisM@Work (5/7/2014)
I was tempted to suggest that only IBG and Jeff's queries can run that fast. Also, that queries running that fast can overheat the processor...
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
May 7, 2014 at 12:09 pm
SQL doesn't use high-precision timers (too resource intensive). Inaccuracy in the order of a few ms is not a problem. Like most rounding issues, the large numbers are accurate enough...
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
May 7, 2014 at 12:08 pm
humbleDBA (5/7/2014)
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
May 7, 2014 at 8:57 am
TheSQLGuru (5/7/2014)
But given the extent of the problem (pun intended 😛 ) I doubt it is from the shutdown itself, or even multiple unexpected shutdowns.
I'm not willing to guess...
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
May 7, 2014 at 8:54 am
You need to figure out why Windows can't see them. Chat with the VM admin. Once Windows can see the processors, then SQL should be able to with at most...
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
May 7, 2014 at 8:52 am
humbleDBA (5/7/2014)
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
May 7, 2014 at 8:09 am
Can Windows see the CPUs?
Were they hot-added?
What edition 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
May 7, 2014 at 8:08 am
Schedulers != CPUs.
You have 8 CPU cores, that means 8 visible online schedulers (one for each core). The hidden schedulers are for background tasks or the DAC, they're created 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
May 7, 2014 at 6:31 am
Corruption is 99.99% IO subsystem problem. Not necessarily the disks, could be anything anywhere in the IO stack.
Since you mentioned an uncontrolled shutdown, I'd check and make sure all write...
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
May 7, 2014 at 5:22 am
Anything like an index rebuild occur between the backup and the checkDB?
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
May 6, 2014 at 1:06 pm
Yes, you can use sys.partitions if you want unfiltered row count. If you want to query the table directly, then SELECT COUNT(*) ...
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
May 6, 2014 at 1:03 pm
Well, not skews results so much as causes task manager to mis-report.
Performance Monitor. Easiest is total server memory under (I think) the SQL Server Memory Manager. You can also go...
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
May 6, 2014 at 12:57 pm
Never use task manager to check SQL's memory. It reports incorrect values when SQL is using locked pages.
The page size is not a concern, 8GB is probably what you have...
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
May 6, 2014 at 11:03 am
What do you mean by '200MB of data' and where are you seeing 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
May 6, 2014 at 10:54 am
Viewing 15 posts - 9,121 through 9,135 (of 49,552 total)