[MS SQL Server] SQL Server Storage in a Virtual Machine (2008 SQL on Windows 2012 on Hyper-V 2012 host) |
- SQL Server Storage in a Virtual Machine (2008 SQL on Windows 2012 on Hyper-V 2012 host)
- backup- fastest
- PowerShell snap-ins
- Does this sound like a good place to enable "Optimize for ad-hoc workloads?"
| SQL Server Storage in a Virtual Machine (2008 SQL on Windows 2012 on Hyper-V 2012 host) Posted: 29 Jun 2013 02:43 AM PDT For a small business where SQL instance is running 8 Databases supporting only 20 users and low number of transactions per second. In a virtual environment do the traditional recommendations for SQL, i.e. separating log files from data files from Temp db on their own spindles still apply? If not and all can reside on the same OBR10 are there pros/cons performance wise for using separate VHDs for each?We are new to RAID and Virtual environments and have read more documentation/articles than I can count. Some advise from those who "Do" will be greatly appreciated. |
| Posted: 28 Jun 2013 09:03 AM PDT Hi,If I have a 100 GB of database and what are the best best options if I need to take a backup( a fastest possible way) to the same server and to backup to a network location ?Thanks. |
| Posted: 28 Jun 2013 05:39 AM PDT Hi,I'm reading through a book on PowerShell and tried the examples about finding the available cmdlets for a snap-in.What seems odd is that even though the book shows output for the commands, the only one that returns results for me is the Core snap-in listing:[code]Get-Command -commandtype cmdlet | Where-Object {$_.PSSnapin -match "core"}[/code]The others, for example, return no results in my PowerShell session.[code]Get-Command -commandtype cmdlet | Where-Object {$_.PSSnapin -match "host"}[/code]Does anyone know why this is? Do I have to load the other snap-ins for them to show up when I issue those commands (PowerShell.Management, Security, etc.)?Thanks for any help!- webrunner |
| Does this sound like a good place to enable "Optimize for ad-hoc workloads?" Posted: 28 Jun 2013 05:35 AM PDT I recently ran the "Server Dashboard" report on a new server here. Imagine my reaction to seeing Adhoc Queries sucking up ~75% of the cumulative CPU Usage and 80-90% of the Logical IO!So I started looking into the "Optimize for adhoc workloads." I read the articles by Kimberly Tripp, Technet stuff, and others, and it sounds like it may not be a bad idea to enable.The server in question only has 4GB of RAM, and I suspect I could put in a request to get it doubled, but it's like pulling teeth from an angry hyena...Running a couple queries agains dm_exec_cached_plans, out of 12975 cached plans, 10148 are adhoc, and 4910 of those are with usecounts of 1...Now, I know enabling this won't immediately have an effect on the plan cache, and it will have something of a detrimental effect on the adhoc queries (no cached plan, takes longer to run.) I'd enable it in a test environment first, but the test server won't get hit as hard as the production...So anyways, does it sound like it might provide some benefit to enable this option?Thanks,Jason |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment