Viewing 15 posts - 23,026 through 23,040 (of 49,552 total)
Put a lower value (that causes it to 'freeze') then go to management studio and see what the shrink is waiting for.
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 6, 2011 at 9:24 am
mendesm (10/6/2011)
GilaMonster (10/6/2011)
mendesm (10/5/2011)
Don't take this personally, but when a resume comes my way with "MCITP/MCTS" and other MS certifications I pass the resume on to the trash barrel.
So 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
October 6, 2011 at 9:13 am
How did you measure the free space? What command did you run to try and shrink?
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 6, 2011 at 9:06 am
What you haven't mentioned is where the free space is. Is it in a data file (if so shrinking or backing up the log is a waste of time)? Or...
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 6, 2011 at 8:35 am
serr4no (10/6/2011)
A service request has been registered with Microsoft, i will update this thread with progress over time.
They're very likely just going to tell you what we've told you already.
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 6, 2011 at 8:27 am
Start with this:
select * from sys.master_files
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 6, 2011 at 7:55 am
What login? What role?
What information should show here?
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 6, 2011 at 7:24 am
Query sys.dm_db_index_physical_stats
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 6, 2011 at 6:32 am
mendesm (10/5/2011)
Don't take this personally, but when a resume comes my way with "MCITP/MCTS" and other MS certifications I pass the resume on to the trash barrel.
So you wouldn't hire...
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 6, 2011 at 2:39 am
isuckatsql (10/5/2011)
Dell had some white papers written that recommended that specific Raid configuration.Raid0 for TempDB was suggested due to its speed.
That's nice. Is it Dell's problem or your problem if...
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 6, 2011 at 2:38 am
isuckatsql (10/5/2011)
I will be using:Raid1 - Program Files (2 HD)
Raid10 - Data files (10 HD)
Raid1 - Log Files (2 HD)
Raid0 - TempDB files 2(HD)
Sure you want to use that? Using...
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 5, 2011 at 5:00 pm
Wayne West (10/5/2011)
EDIT: I misunderstood your post initially, I thought you were talking about hex editing the backup to purge data.
No, that would be a good way of ensuring...
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 5, 2011 at 3:45 pm
For anyone who wants a deep (and I do mean Deep) dive into Windows memory internals from one of the Windows Kernel team, see these videos.
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/WCL405
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/WCL406
They probably need watching 3...
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 5, 2011 at 3:42 pm
How strictly is 'purge' defined? If I can take a hex editor, read the disk raw and find the data there is it a violation?
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 5, 2011 at 3:32 pm
jared-709193 (10/5/2011)
I believe that the page file will always be used when enabled no matter what your memory size.
Yes, it will always be used because Windows will be pro-actively writing...
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 5, 2011 at 3:23 pm
Viewing 15 posts - 23,026 through 23,040 (of 49,552 total)