Forum Replies Created
Viewing 15 posts - 21,541 through 21,555 (of 49,552 total)
-
RE: Using sys.dm_os_memory_objects to analyze memory use and identify possible memory leaks
opc.three (12/27/2011)
The consensus of some of the business users that write SQL for this instance is that we need to reboot the server periodically due to the possibility of a...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Need a solution to my scenario
Functions = slow. Avoid unless there really is absolutely no other way.
You haven't given us enough info to help you here. Please post table definitions, sample data and desired output....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: System Database
Dhirju (12/27/2011)
but model database is template of creating new database, so why we set to full? it can be set to simple also.As I said in my post, it should...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: System Database
Master defaults to simple and, even if set to full still behaves like simple (can't take log backups), so leave that as is.
TempDB is simple and cannot be changed...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Using sys.dm_os_memory_objects to analyze memory use and identify possible memory leaks
I suspect what you'd be looking for in sys.dm_os_memory_objects is entries that only increase their page counts, never decrease. It's difficult though, as many of the caches do have 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Using sys.dm_os_memory_objects to analyze memory use and identify possible memory leaks
Dev (12/27/2011)
2. Check the memory usage of SQL Server. To check the memory usage, click the "Processes" tab on the Task Manager scroll down until "SQL Server"...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Schedule 2008 R2 to restart every day/week
tnelson-735283 (12/26/2011)
Instance is running on a VM and I'm trying to keep memory usage to a minimum.Then set server max memory to an acceptable value and SQL will limit its...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Schedule 2008 R2 to restart every day/week
Why do you want to do this?
Scheduled task would be the way to go, if you were going to do something like this.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Using 2005 rather than 2008
Let me just say this:
SQL 2012 is expected first half of next year. When that comes out, SQL 2005 will be 3 major versions old, it's heading for end 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: SQL Server Authentication
http://msdn.microsoft.com/en-us/library/ms144284.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Question on index column ordering
Don't just focus on logical reads. Look at logical reads, duration and CPU. If the duration and CPU haven't changed much then maybe that increase in logical reads is an...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Roy Ernest (12/23/2011)
Is that your back yard? It is gorgeous. 🙂No, but I'll take that as a compliment. It's a 3D computer generated image.
My mother has a pond. Her...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Right, I'm outta here... Merry Christmas to anyone who's still 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Question on index column ordering
Primary key to clustered and a NC on the 3 columns is probably best, but the problem is that if that NC is not covering (and if all columns are...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: TRY + CATCH + PARTIAL ROLLBACK
Yes, insert the error information into a table variable, do the rollback in the catch block (or you'll be left with an uncommitted transaction) then insert the contents of 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 21,541 through 21,555 (of 49,552 total)