Hey Guys,
Is it a bad idea to put Exchange and Sql Server on a same box?
We have about 4-5 GB database and 10 users for exchange, can this work?
Thanks
I have a scenario based question...Something , I haven't faced till now ,but i would be interested to know the answer.
If i have assigned a luns (say, of 50 GB) and put them in storage group.However, the windows server team did not grab that lun but sent an acknowledgment saying the Luns are alingned.
I would like to know what will happen to the Luns that belong to the SG ..in my opinion they will remain in the SG as unassigned Luns ..or is there a possibility that the lUns will move back to the storage.
Hello,
I run into the same issue as someone who posted this question on experts-exchange.com (couldn't read the answer though as I don't have an account there):
{Quote Begin}
I noticed that the 180-day Evaluation version of SQL Server 2008 is the
Enterprise version. Is there going to be any problem "upgrading" the Evaluation Enterprise
version to a licensed STANDARD version (and how much additional stuff is going to be
left inactive on my disk and, more importantly, in my registry, etc. if I do
so)?
{Quote End}
Any advice is appreciated.
I have 8 SQL Server installations (on 8 separate servers).
I want a way in which I can estimate future disk space requirements. Can anyone list down the parameters which can be helpful in making such reports?
I've been tasked with taking over the administration of a MySQL installation (running on Red Hat Linux) that will become fairly critical to our business in the near future.
I was wondering if anyone could recommend some resources in regards to administering MySQL for DBAs already experienced with other relational database (SQL Server and some Oracle in my case). Specifically I'm looking for information around disaster recovery as well as high availability to start with, but I do want to get well rounded with the entire system.
Thanks in advance,
Dan
I have 3 very underutilized servers that I am condensing to one of those shuttle PC's with VMWare ESXi
The HDD seems to be the bottle neck right now (the light is almost always pure solid) right now I have a single 1TB Seagate 7200.11 connected by SATA. VMWare ESXi cannot detect it when running in AHCI mode, but does when running in IDE mode. I have read that IDE mode can give a 5% performance hit which might give me enough breathing room.
However, I am open to setting up an external eSATA or some sort of raid to give me more than just the 5%. I am just weary of sinking some money into a bit of hardware without knowledge of whether it will work.
Does anyone know of resources or procedures of how to get this working.
here can I find somewhat reliable indications of server market shares, without having to fork out $$$$$ for IDC or Gartner reports?
I have considered the W3 statistics, net applications etc, and these are not what I would consider reliable.
Is there anything more, that is free?
Hi,
On a SQL server, why do we need a weekly update stats job (with full scan) when we have AUTO_UPDATE_STATISTICS=ON for all databases?
Doesn't this option update statistics all the time?
Regards
I have a local user of a windows Server 2008 that is a member of builtin Users group, a program that run this user need to have write access to a Key located in the HKEY_LOCAL_MACHINE, can i enable this user to have write access in HKLM without adding it to Administrators group ?
Thanks.
I have folder to be shared on window server 2008.
If i disable all firewalls then MAC can see the folder
If i enable firewall then MAC can't connect to my folder
WHich rule i have to apply in firewall setting to make that share work
Now that Windows Server 2012 comes with de-duplication features for NTFS volumes I am having a hard time finding technical details about it. I can deduce from the TechNet documentation that the de-duplication action itself is an asynchronous process - not unlike how the SIS Groveler used to work - but there is virtually no detail about the implementation (algorithms used, resources needed, even the info on performance considerations is nothing but a bunch rule-of-thumb-style recommendations).
Insights and pointers are greatly appreciated, a comparison to Solaris' ZFS de-duplication efficiency for a set of scenarios would be wonderful.
I am trying to figure out how I can connect to an ESX server's storage system so that I can upload VM image files. I am a windows user if that matters (i suspect it does).
Thanks in advance
Please provide your tips and best practices for virtualizing SQL Server in VMWare ESX
I am interested in advanced configurations and settings.
Please provide reasoning behind your recommendations
Edit:
Just to clarify, I already have over 70 Virtual SQL servers in separate clusters using an ISCSI equallogic San -
What I am really looking for are those advanced configurations like:
How you configured your disks / RDM's
Do you make use of settings like
Mem.ShareScanGHz - http://communities.vmware.com/thread/143828 -
that are not well documented
I have a Sql Server database that has a few tables with zero row count but take up a combined 10 GB of space. I can see this by doing right-click/properties on the tables in question (data space is huge, between 1 and 6 GB, and row count is zero on these tables). I have no clue what could be causing this as I would assume zero rows would mean nearly zero space taken.
Any ideas?
Hi,
I was asked to drop some tables on a Company SQL 2005 Server and provide proof of deletion because of these tables contains sensible data. Is it possible?
Thank you all for help
Am I correct that the NET TIME command should return the time from the PDC for the domain?
If so, the issue we are contending with is that NET TIME command returns \randomfileserver.
How do I reset time server for domain to be the PDC?
Hi,
I am wanting to setup a internal development server (LAMP), I need the web team to be able to access different developments sites ie:
example1.local
example2.local
example3.local etc
from within the network.
I believe it would be something to do with DNS?
Any help would be appriciated.
Kyle
I have a SQL server behind a firewall. I need to push some limited SQL 2005 information to a Web Server in the DMZ so that I do not have to let database queries come all the way into the database server on our internal network. I want to push a small amount of dynamic data to a Web server in the DMZ and lock it down so that our hosted website does not need to come into the internal network for information; I want to put a server in the DMZ that will be the only connection allowed to the SQL database. This DMZ server will be the only server that can have any sort of connection to the back-end database so the hosting provider just pull the data from our server in the DMZ...
My understanding is that VMMs such as VMware's ESXi Server maintain shadow page tables to map virtual page addresses of guest operating systems directly to machine (hardware) addresses. I've been told that shadow page tables are then used directly by the processor's paging hardware to allow memory access in the VM to execute without translation overhead.
I would like to understand a bit more about how the shadow page table mechanism works in a VMM.
Is my high level understanding above correct?
What kind of data structures are used in the implementation of shadow page tables?
What is the flow of control from the guest operating system all the way to the hardware?
How are memory access translations made for a guest operating system before its shadow page table is populated?
How is page sharing supported?
Short of straight up reading the source code of an open source VMM, what resources can I look into to learn more about hardware virtualization?
Hi, I have Windows 7 64bit, 8gb ram and 1152mb is hardware reserved which leaves me with 7039mb of physical memory available as I can see on the task manager. What is the advantage or disadvantage of keeping it this way?
If I disable it from the MSCONFIG, the hardware reserved comes down to 1mb. Well, which way I should keep it for best performance in all meanings considering that nowdays, 8gb is still a lot. Could someone explain the easy way please?
This question already has an answer here:
What permissions should my website files/folders have on a Linux webserver?
4 answers
I have a dedicated server for my website. There are no other users, and no other websites on the same machine.
Is there any risk in setting 777-permissions on my site's public_html folder, bearing in mind configuration files with passwords and access keys are stored outside that root?