Tag Info

Hot answers tagged

3

There is no inconsistency: 1048576 * 8 = 8388608 KB => 8 GB; Both Perfmon and sys.dm_os_sys_info show 8 GB; [bpool_visible], [bpool_commit_target] and [bpool_committed] - in SQL 2005 all these are defined as "Number of 8-KB buffers ..." (http://msdn.microsoft.com/en-us/library/ms175048(v=sql.90).aspx), so you have to multiply the result by 8 to get ...


2

If all you want to do is keep track of which authors contributed to which papers, then all you need is a simple intersecting entity (see more) like this: Here the columns of the SUBMISSION table are just the two primary key columns from PAPER and AUTHOR. These two columns will jointly form the primary key of the intersecting table and will also each ...


2

Automatic failover requires a witness. See Database Mirroring Witness: To support automatic failover, a database mirroring session must be configured in high-safety mode and also possess a third server instance, known as the witness. The witness is an optional instance of SQL Server that enables the mirror server in a high-safety mode session to ...


2

The issue was the setting "Auto close" was set to true on a series of databases on the server. Even though the databases were unrelated their "auto close" setting was flushing all execution plans on the server. Here are the types of log issues you will see with auto_close set to true: SQL Server has encountered 24 occurrence(s) of cachestore flush ...


2

There are no architecture differences in RMAN itself. The difference is in the speed of the backups if written to the Exadata on-board storage. So the advantages that Exadata brings in terms of hardware would also translate to advantages in backup speed and MTR (mean time to recovery). But none of those advantages are the result of changes to RMAN.


2

In your question, there is not enough information to see where the problem is from technical point of view; however, I can see that there is a problem in communication between you as developer and the DBA. This is not abnormal though as DBAs and devs do not always 'speak the same language'. Let's go the some points in your question: You should rely on the ...


2

So let's look at the "roles" here represented in the referenced architecture. Keep in mind, this is the "2 cent tour" of what the architecture is all about. Mongos This process is the "router" in that it acts as the interface for a "client" to connect to a sharded cluster. You can have many mongos instances, so you are not limited to "one" only. As ...


2

The actual costs are difficult to quantify as they are often diffused. Often they appear as slower transactions. For a system used rarely, this may not be significant. For a system used for an hour a day, that is taking twice as long as is required the cost would be about 100 hrs a year per person using the system. Slower transactions may also have ...


1

You won't get any specific answer to this question, because as you observed, it depends. The answer depends on your company's tolerance for having one DB2 instance adversely impact the performance of another's. You may be able to control or limit this impact if your AIX admins are willing to learn and set up WLM policies at the operating system level (not ...


1

Your database isn't open. Open it using the below command. alter database open;


1

In short, no it won't work. There are two types of windows authentication, local and domain. Seeing as how you're asking about your domain logon, that's clearly the second kind. When you try to authenticate to a domain logon, the local machine will go up the chain in its domain group, and ask for a domain controller to authenticate your credentials. Seeing ...


1

Plan answer: No. Let me explain: Windows Authentication is just that, authenticating with a Window's login. So if you are dealing with a workgroup computer where you are on a domain it will not work, because that server can only authenticate a local account. If you are talking about connecting with SSMS, you can try the runas coomand through command ...


1

I have four(4) old posts to demonstrate how to measure and size up the InnoDB Buffer Pool based on the amount of RAM on the DB Server and how much space is currently being taken up by data/index pages: Apr 14, 2011 : What are the main differences between InnoDB and MyISAM? Oct 22, 2012 : How much memory do I need for innodb buffer pool? Oct 22, 1012 : How ...


1

There are several methods you can use such as mysqldump folder copy enterprise backup for mysqldump use following command: mysqldump -uuser -ppassword --database your_db_name --routines --triggers --events --lock-all-tables >outputfile.sql and use following command at destination: mysql -uroot -ppassword<outputfile.sql. You can also use ...



Only top voted, non community-wiki answers of a minimum length are eligible