Viewing 15 posts - 18,466 through 18,480 (of 49,552 total)
andersg98 (5/22/2012)
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 22, 2012 at 2:02 pm
Take a read through this: http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
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 22, 2012 at 1:59 pm
Page count is the number of pages that the data in the table takes up, each page is 8kb. The only reliable way to decrease that is to delete data.
Don't...
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 22, 2012 at 1:56 pm
Watch it over time and see if it is using CPU and doing more IOs
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 22, 2012 at 9:43 am
Same as above.
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 22, 2012 at 7:33 am
32 bit OS and 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 22, 2012 at 7:23 am
it's probably not doing anything, you can confirm that by watching sys.dm_exec_requests, the CPU and reads columns. You will very likely need to restart sometime to get rid of it,...
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 22, 2012 at 7:22 am
Restart 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
May 22, 2012 at 7:08 am
Page numbers are just sequential, starting at 0 and increasing per file. Hence pages are identified by the format 1:43, the 43rd page in file 1.
p.s. If you want to...
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 22, 2012 at 5:23 am
That's not the full output. If you want an accurate assessment of the damage and your options, please post the full and unedited output of the checkDB command (or save...
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 22, 2012 at 2:13 am
http://www.sqlservercentral.com/articles/Recovery+models/89664/
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 21, 2012 at 4:09 pm
There are two aspects to this:
- Size of the log file
- Size of the active portion of the log
If the log file does not exist (so restoring to...
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 21, 2012 at 4:06 pm
Short of calling Microsoft, probably not.
Why is it important though? The only thing that will tell you is how long they've been out of support.
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 21, 2012 at 12:41 am
There's a difference between a file-level snapshot (which Steve it thinking of) and a VDI SAN snapshot backup which really is a full database backup with some really weird SAN...
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 20, 2012 at 2:45 pm
This is as good a place as any to ask.
Please put questions in their own threads, with a descriptive title. That increase the chance that someone will answer you...
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 19, 2012 at 12:22 pm
Viewing 15 posts - 18,466 through 18,480 (of 49,552 total)