Viewing 15 posts - 15,181 through 15,195 (of 49,552 total)
Lowell (12/18/2012)
GilaMonster (12/18/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
December 18, 2012 at 6:36 am
I recommend restoring from the last good full backup. Since the DB is in simple recovery model, that amount of data loss (since the last full backup) must be acceptable...
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 18, 2012 at 6:00 am
If you repair, you will lose data.
If you want to avoid data loss, then you need to take a tail-log backup, restore the last clean full backup and all log...
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 18, 2012 at 5:36 am
Restore from a clean backup.
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 18, 2012 at 5:15 am
itsmemegamind (12/18/2012)
You can perform this operation via some third party tool like this
Or you could save the expense of a completely unnecessary tool, as all that will do is call...
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 18, 2012 at 5:13 am
Ok, So Memory/pages\sec
That's the count of hard page faults (page faults/sec are soft page faults). That's to do with pages that are in virtual memory but not physical memory (ie...
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 18, 2012 at 4:28 am
SQL doesn't keep track of how it's licenced, that's paperwork. (other than SQL 2012 in one case)
As for server name, version and edition, have a look at the MAP tool...
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 18, 2012 at 4:08 am
mjwlufc (12/18/2012)
The memory objects i'm lookin at are pages /sec and page faults/sec
Which pages/sec? Under which section? There are multiple pages/sec counters in different sections and they mean different things.
Since...
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 18, 2012 at 3:38 am
Sure it's possible. It's just going to be a normal merge replication setup.
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 18, 2012 at 3:34 am
mjwlufc (12/18/2012)
The instance has AWE enabled, is the view this is better to have on than off ?
32 bit or 64 bit SQL?
Whilst i was in perform i noticed 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
December 18, 2012 at 3:21 am
Mac1986 (12/18/2012)
Also, what is size that can be on a general note can be determined as LOB? Can you possibly give an approx number?
Huh?
LOB = Large Object. Nvarchar(max), Varchar(max), varbinary(max),...
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 18, 2012 at 3:17 am
Why are you ending up with so much free space that's not going to be reused?
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 18, 2012 at 2:40 am
No, it's just that LOB columns massively slow down shrinks because of the way they pages link together.
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 18, 2012 at 2:30 am
DBCC Shrinkfile is the only way to release unused space back to the OS.
Let me guess, either lots of heaps or lots of LOB columns?
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 18, 2012 at 2:19 am
Any way you like.
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 18, 2012 at 2:08 am
Viewing 15 posts - 15,181 through 15,195 (of 49,552 total)