At a customer of ours, the sql server is configured to 1 for degree of parallelism. The server has 8 cpu's, so what would be reason to limit this degree to 1?
I'm looking for something I can install on a Linux server to create a remote calendar that I can sync with my iPhone.
Anything requiring setting up an Exchange Server connection on the iPhone is out since I already have one set up for work. I'd like to avoid a groupware package since all I really want is a calendar.
I have an HTTP Server Service application which has its own logging mechanism. It's written in Delphi. I would like to provide a way for multiple clients to connect to this service and get a real-time update of the log. The log in the service moves rather fast, there's a lot of things to log. There may be up to 50 messages within 1 second at times. The existing log which is already implemented is not saved, it's only kept in the memory of the server service - where I will need to distribute it to any client which needs it. Once all clients have a log message, it should be deleted.
I intend to use HTTP to "ask" the server for the log, and respond with an XML packet. The connections are not keep-alive. The only problem is, the server should only send the client those log records which it needs, not everything. I have no way of the server pushing the log to the clients in real-time, so each client needs to repeatedly ask the server for the latest log records. This HTTP Server is very lightweight, and there is no session management. There isn't even any type of authentication.
The only way I see is for a client to register its self on the server, and whenever a log is issued on the server, it creates a copy of the log for each client, where each client has a log queue (string list). However, suppose there are 100 clients connected and expecting to receive this log. That means the server must create 100 copies of each log, add this log to the end of each client log queue, and wait for the client to request it. At that point, when the server replies with the XML log, it should flush (delete) whatever's in the queue. I'm worried however that this could cause memory issues. Each client log queue might get 100 log messages before the client requests the latest logs.
How should I go about doing this in the fastest way possible without hindering the performance of the server? I'm trying to avoid having to create a copy of each log for each client.
SharePoint installation guidance specifies that SQL Server collation should be set to Latin1_General_CI_AS_KS_WS (case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive). However, our internal hosting group uses the default SQL Server 2005 collation SQL_Latin1_General_CP1_CI_AS. What are the potential issues we might face with MOSS 2007?
A quick question.
How many copies of the same movie are kept in a video server (a video streaming server)? Suppose a particular video is at max requested by 1000 users at the same instant of time, how many copies would be sufficient so that parallel streams can be provided to each user? Ideally 1 copy would solve the purpose, but what is the optimum number keeping the bandwidth and simultaneous access in mind?
We're currently using SQL Server Express 2008 as backend for our TFS2010 install (Basic). Would it be possible to move to the standard (or better) version of SQL Server without any big hassels?
Is there any way to allow access a network share on Windows Server 2008 to a specific Vista Home machine/user?
I have two Vista Home machines on my network (ugh) and I need a user from one of them to be able to access a network share on my new server 2008 DC. How ever I don't want to just allow "everyone" access.
I wrote a small utility to script some key SQL Server configuration information. I had two goals for this utility: Assist with disaster recovery preparation Identify configuration changes I’ve released the application as open source through CodePlex. You can download it from CodePlex at the Script SQL Server Configuration project page. The application is a .NET 2.0 console application that uses SMO. It writes its output to a directory that you specify. Disaster Planning ScriptSqlConfig generates scripts for logins, jobs and linked servers. It writes the properties and configuration from the instance to text files. The scripts are designed so they can be run against a DR server in the case of a disaster. The properties and configuration will need to be manually compared. Each job is scripted to its own file. Each linked server is scripted to its own file. The linked servers don’t include the password if you use a SQL Server account to connect to the linked server. You’ll need to store those somewhere secure. All the logins are scripted to a single file. This file includes windows logins, SQL Server logins and any server role membership. The SQL Server logins are scripted with the correct SID and hashed passwords. This means that when you create the login it will automatically match up to the users in the database and have the correct password. This is the only script that I programmatically generate rather than using SMO. The SQL Server configuration and properties are scripted to text files. These will need to be manually reviewed in the event of a disaster. Or you could DIFF them with the configuration on the new server. Configuration Changes These scripts and files are all designed to be checked into a version control system. The scripts themselves don’t include any date specific information. In my environments I run this every night and check in the changes. I call the application once for each server and script each server to its own directory. The process will delete any existing files before writing new ones. This solved the problem I had where the scripts for deleted jobs and linked servers would continue to show up. To see any changes I just need to query the version control system to show many any changes to the files. Database Scripting Utilities that script database objects are plentiful. CodePlex has at least a dozen of them including one I wrote years ago. The code is so easy to write it’s hard not to include that functionality. This functionality wasn’t high on my list because it’s included in a database backup. Unless you specify the /nodb option, the utility will script out many user database objects. It will script one object per file. It will script tables, stored procedures, user-defined data types, views, triggers, table types and user-defined functions. I know there are more I need to add but haven’t gotten around it yet. If there’s something you need, please log an issue and get it added. Since it scripts one object per file these really aren’t appropriate to recreate an empty database. They are really good for checking into source control every night and then seeing what changed. I know everyone tells me all their database objects are in source control but a little extra insurance never hurts. Conclusion I hope this utility will help a few of you out there. My goal is to have it script all server objects that aren’t contained in user databases. This should help with configuration changes and especially disaster recovery.
Hi Guys,
We get a weekly Summary Network Report from our SBS 2008 server, delivered by email.
The report contains many alerts. We want to ignore some of them so that the report is all green and any alert will stand out. For example, we want to ignore the alert regarding the firewall being off on the server.
Is there a place where I can select what points to check and the level of some alerts (such as low remaining disk space), etc?
I'm having a rather tough time finding information on this since almost everything I read requires Management Studio installed in the server which I prefer not to do.
Also, to connect to it using SQL Server Management Studio installed on the client, are these settings ok?
ServerName: 10.232.234,1433\SQLEXPRESS
Login: sa
Password: password
Yes, I want to specify the port number in the client side since I have to go through a few firewalls which I have poke holes through to get to the SQL Default port 1433.
I need to configure windows NLB on 2 dedicated servers I have.
My main machine has been running for some time, with several domain names pointing to the servers primary IP address.
Both servers have 2 NIC's installed, and both have several secondary public IP addresses available if needed?
What IP address would I use for the cluster IP, does this IP need to be added to the IP list of both public NIC's ip address list?
What IP addresses do I use for the host's dedicated IP?
Please help, this is driving me nuts...i've taken down the server twice on accident today!
UPDATE: Looking to hire a windows SysAdmin to solve!
I have updated my question, i would like to hire a trusted windows SysAdmin to take care of this for me, preferably today...can anyone help and provide some credentials please?
Thank you in advance!
I bought a small 256MB slice from slicehost and installed Ubuntu 10.04 64bit and wordpress on it. Performance was dismal as apache was eating up all my memory. Once I did some taming of apache and switched to fCGI things ran fine.
Next I rebuilt as a 32 bit server, and performance was much better.
What benefit would I get from a 64 bit server. Is it all about the memory?
The content on the Server 2008 R2 Trial Software page states that it can be evaluated for upto 180 days, however on a test machine we installed last week, it's requesting "re-arming" every 10 days, which seems to be do-able a maximum of 5 times?
How do we get it to last more than 50 days, as it'd be a pain to have to rebuild the server concerned!
I bought a VPS server yesterday. Server companies support is not avaible for now. I am going to set dns adress. So i know 1 ip number they gave to me, how can i learn how many ip's i have and what are they? Is there command for ubuntu for that? Or any other way?
Id like to know the answer to this question:
Are there any server hosting plans out there that provide a physical modem connected to the machine? I am writing an app that needs to send commands directly to a modem physically attached to the machine (obviously, it needs to be a dedicated server).
There are numerous advantages to server scripting languages over client side languages in regards to creating web sites that are more compelling compared to a standard static site. Server side scripting are scripts that are executed on a web server during the compilation of data to return to a client. These scripts allow developers to modify the content that is being sent to the user prior to the return of the data to the user as well as store information about the user. In addition, server side scripts allow for a controllable environment in which they can be executed. This cannot be said for client side languages because the developer cannot control the users’ environment compared to a web server. Some users may turn off client scripts, some may be only allow limited access on the system and others may be able to gain full control of the environment. I have been developing web applications for over 9 years, and I have used server side languages for most of the applications I have built. Here is a list of common things I have developed with server side scripts.
List of Common Generic Functionality
Send Email
FTP Files
Security/ Access Control
Encryption
URL rewriting
Data Access
Data Creation
I/O Access
The one important feature server side languages will help me with on my website is Data Access because my component will be backed with a SQL server database.
I believe that form validation is one instance where I might see server-side scripts and JavaScript used interchangeably because it does not matter how or where the data is validated as long as the data that gets inserted is valid. However, I would have to say that my personal experience would have to sway me in deciding what type of languages to use for form validation because they both have advantages and disadvantages based on the each situation.
Can I set up the Reporting Server of the Express Edition in some way to work integrated in my sharepoint services site?
I have the reporting-server Add-in on the sharepoint machine and see the itmes in the central administration.
I'm doing the following to mount a remote server to a specific path on my server:
sshfs [email protected]:/backup/folder/ /home/myuser/server-backups/
However when I mount the server the folder permissions change (they become 700), and when I test my rsnapshot.conf file I get the following error:
snapshot_root /home/myuser/server-backups/ - snapshot_root exists \
but is not readable
What am I doing wrong ? should I mount the remote server with another user ?
Couldn't find any help @ google or here.
The scenario:
Windows Server 2008 Std x64 on i7-975, 12 GB RAM. The server is running in a data centre.
One hardware NIC - RealTek PCIe GBE - one MAC Address.
The data centre provides us 4 static external IP's. The first is assigned to the host by default of course.
I have ordered all 4 IP's, the data centre can assign the available IP's to the physical MAC address of the given NIC only. This means one NIC, one MAC Address, 4 IP's. Everything works fine so far.
Now, what I would like to have:
Installed VirtualBox with 1-3 guests running, each gets it's own external IP assigned.
Each of it should be an standalone Win Server 2008.
It looks like the easiest way would be to put the guests into an virtual subnet and routing all data coming to the 2nd till 4th external IP through to this guests using there subnet IP's.
I have been through the VirtualBox User Manuel regarding networking.
What's not working:
I can't use bridged networking without anything else, because the IP's are assigned to the one MAC address only.
I can't use NAT networking because it does not allow access from outside or the host to the guest. I do not wanna use port forwarding.
Host-only networking itself would not allow internet access, by sharing the default internet connection of the host, internet is granted from the guest to the outside but not from outside or the host to the guest.
InternalNetworking is not really an option here.
What I have tried is to create an additional MS Loopback adapter for a routed subnet, where the Vbox guests are in, now the idea was to NAT the internet connection to the loopback 'subnet'. But I can't ping the gateway from the guests.
By using route command in the command shell or RRAS (static route, NAT) I didn't get there as well.
Solutions like the following do work for the one way, but not for the way back:
For your situation, it might be best
to use the Host-Only adapter for ICS.
Go to the preferences of VB itself and
select network. There you can change
the configuration for the interface.
Set the IP address to 192.168.0.1,
netmask 255.255.255.0. Disable the
DHCP server if it isn't already and
that's it. Now the Guest should get an
IP from Windows itself and be able to
get onto the internet, while you can
also access the Host.
Slowly I'm pretty stucked with this topic.
There is a possibility I've just overlooked something or just didn't getting it by trying, especially using RRAS, but it's kinda hard to find useful howto's or something in the web.
Thanks in advance!
Best regards,
Simon
I have a windows 2012 server with 3 storage spaces set up, each containing a mirrored pair of 2TB drives.
What is the best way to set up alerting so that i receive an alert when a physical disk fails?
Ideally i would like these alerts to be sent via email to a pre-defined address.
The current server set up is as follows:
Intel Core i7 2600k 3.4GHz Socket 1155 8MB Cache
Asrock H77 PRO4/MVP Socket 1155 VGA DVI HDMI 7.1 Channel Audio ATX Motherboard
16GB RAM
1 x 60GB SSD (OS)
6 x 2TB SATA III 7200 HDD (DATA)
While i'm sure i can write a CRON to do this and some how open the ports on a network hd in my house, to be honest i'd rather spend a bit of money on some good software with a nice visual interface..
are there any such all-in-one server backup systems?
nightly backups of the MYSQL db
weekly backups of entire site (images etc)
my server is a VPS hosted by https://www.memset.com
I'm actually using Microsoft Hyper-V Server, which I would think would be similar to a server core installation.
My goal is to use OpenFiler to store my VHD files and access them via iSCSI.
Hello,
I am trying to configure a Report Server on SQL Server 2005 and need to change the ASP.NET Web Service Account.
Can anyone point me in the right direction of how to do this.
Thanks
Andy
I'm looking for resources that can teach me how to properly read a sql server execution plan.
I'm a long time developer, with tons of sql server experience, but I've never really learned how to really understand what an execution plan is saying to me.
I guess I'm looking for links, books, anything that can describe things like whether a clustered index scan is good or bad along with examples on how to fix issues.
I'va remote linux debian server that 99.9% of the time I access via ssh remotely. However I was aware that the local terminal is sitting there with a logon prompt. Is there anything I could change this to, or log in and run locally and safely leave running? Physical access to the server is limited to me but a secure situation would be preferable.
Thanks..
Ian