Operating system produced by Microsoft. Windows is produced in various desktop and server versions.
3
votes
1answer
692 views
MySQL Server Performance
I have a few questions regarding MySQL server running under Windows Server 2008 R2:
How do I check the number of allowed connections?
How do I turn on query logging to see performance of queries ...
2
votes
1answer
197 views
FLUSH TABLES stays in the processlist even after execution
Here is my code from Stored Procedures in Mysql
FLUSH TABLES;
TRUNCATE TABLE tbl_cdrload;
TRUNCATE TABLE tbl_cdrdetails_temp;
Then i execute a query to load a file in to database as below
LOAD ...
3
votes
1answer
3k views
SQL Server 2008 R2 on Windows 7 x64 Professional - what are the downsides?
I need to minimize the cost of the platform, that will run SQL Server 2008 R2 Standard Edition. I have a special licensed version of this SQL server to work with like 20 users (it's an 1C special ...
2
votes
2answers
388 views
What is the recommended Buffer Pool size on a 2GB RAM PC?
I installed DB2 Express-C on a PC with 2 GB RAM and running Windows Server 2008 R2 OS. While creating a new database, there is an option to set Buffer Pool size with default set to 4K.
How much is ...
1
vote
1answer
419 views
Very Large Log Files
I'm running Windows Server 2008 R2 and executed a large query by accident. Next, the sever ran out of hard drive space.
I now have a file in my administrtor documents (log.log) that is over 18GB. I ...
2
votes
1answer
217 views
How can I restore a MySQL database after formatting my hard drive
I recently formatted my PC which had MySQL running on it. As a result, I lost the databases on my hard drive.
I tried to restore the databases by re-installing the MySQL Server and putting the ...
1
vote
1answer
221 views
Change root password of mysql database
This could be a Rookie problem , but it seems that i am not able to solve it.
I have MySQL server installed on my windows machine(MySQL 5.5) under the Admin username root.
Some How i lost the ...
4
votes
1answer
579 views
Oracle Database Enterprise Users & Roles with Microsoft Active Directory?
We have a legacy application and we have full access to source code and platform running it, so virtually any change can be implemented if required.
The application is a Java Swing heavy-weight GUI ...
1
vote
1answer
64 views
Log Custom SQL Results During Maintenance Plan
I would like the last step of my Maintenance Plan to execute a simple custom SQL script (SELECT * FROM <SomeTable> WHERE <Condition>), and save the results to a file (Text, CSV, etc).
Is ...
2
votes
0answers
72 views
ProcessID Owner with third party app
I am having problems trying to audit a third party app with a SQLServer backend.
The app manages users and user access via a SQL table, using a single SQL login to access the databases.
I am trying ...
2
votes
1answer
346 views
PostgreSQL 9 'pgstats wait timeout' problem
I'm asking about this here because in the PostgreSQL mailing lists no one answered me.
In one of my servers (Windows 2008 R2 Standard/PostgreSQL 9.0.5 64 bits) the logs are being flooded with the ...
3
votes
1answer
88 views
migrating from SQL server 2005 to 2008
I had SQL server 2005 installed on my windows server 2008 R2.
Recently i installed SQL server 2008 and SQL server management studio 2008 r2 (SSMS) on my virtual server and i configured the instance ...
2
votes
0answers
492 views
Copy database wizard between servers results in Access Denied error. [closed]
I'm trying to copy a database from SQL Server 2008 R2 to another server, using the Copy Database Wizard in SQL Server Management Studio.
I get an error telling me to check the error log on the ...
4
votes
2answers
1k views
Import Oracle full dump file to fresh Oracle installation
I am importing a Oracle dump fill created on a AIX Oracle 9.2 installation with a Full Export option to a Windows Oracle 10.2.0.4 on Windows 2008 R2 x64.
I want to import the file to a clean ...
1
vote
1answer
350 views
Tutorial for installing and setting up 'streaming replication' with PostgreSQL on Windows XP
Please refer to the diagram in the link below. While looking at my goals.
http://i.stack.imgur.com/GkVWb.png
GOAL:
Get PostgreSQL 9.1 running on 3 terminals on the 'on site' location.
'on ...
0
votes
1answer
71 views
can I copy-paste SQL Server 2005 Express on XP Pro or Vista machine and make it work without installer?
I am having installer problems on several machines trying to install SQL Server Express 2005 Express as well as later versions (but I would be happy with 2005 anyway). However, I do have one machine ...
9
votes
1answer
258 views
What does a SQL Server DBA need to know about Windows Server?
Analogous to my previous question What does a DBA have to know about SSAS?, which generated a really wonderful answer (thank you, @ConcernedOfTunbridgeWells!), I now ask a similiar question:
What ...
1
vote
2answers
383 views
MySQL Database and Table Loss
I have installed mysql and XAMPP on my system. I wanted to remove the mysql service of XAMPP. After removing it, I tried to install the new service for mysql using "MySQLInstanceConfig.exe". but now I ...
3
votes
2answers
700 views
ORA-04031: unable to allocate bytes of shared memory (“”,“”,“”,“”)
I am receiving this error in a development database.
It happens on some specific queries (simple inserts and deletes via .NET application).
The database is used by one user, and error happens ...
6
votes
2answers
671 views
securely exposing sql server 2008 for windows authentication
My company wants to have approximately 100 of their sales people (distributed around the country) to be able to run stored procedures from excel and return the data onto the spreadsheet.
We have sql ...
1
vote
3answers
614 views
MySQL SSL disabled on Windows
I want to enable an SSL connection to my database. I've created SSL certificates and so on, however SSL remains disabled:
mysql> show variables like '%ssl%';
...
4
votes
2answers
627 views
Does the PCI standard forbid the use of Windows Authentication?
We currently use Mixed Mode for our SQL Server Authentication. I've tried to convince our DBA to allow us to use Windows Authentication so we can use Team Foundation Server, however he absolutely ...
2
votes
2answers
582 views
Separate tables or partition one huge table?
I'm building a rather large table that includes a particular column, my_column. There are a small-ish number of possible values for my_column, and each unique value of my_column should have the same ...
3
votes
1answer
851 views
Converting Microsoft SQL Server collation to UTF 8
I've a Rails-Application, which reads data from a Microsoft SQL Server 2008 R2 Database.
All umlauts are represented by a '?', so I checked the encoding of the database. The encoding is 'Latin 1'. ...
5
votes
2answers
4k views
PostgreSQL: The database cluster initialization failed
Both C:\PostgreSQL and C:\PostgreSQL\data have postgres user with full access and admin rights.
I ran postgresql-9.1.2-1-windows.exe from postgres user as admin. Target C:\PostgreSQL
Every way I ...
2
votes
3answers
2k views
Can I specify a different disk for a specific MySQL table?
I use my home machine as my personal database for my hobby analytics project. This machine has an SSD for the main drive where MySQL stores its data. It also has a secondary hard drive that is ...
1
vote
2answers
551 views
Which oracle should I download for windows 7 x64?
My os is: windows 7 x64
I tried to download oracle and install it in my computer, but I have downloaded 3 different oracle releases(including oracle 11G), they can't be installed.
They reported ...
4
votes
1answer
349 views
Not all members in a Windows group have permissions
I ran into a bit of an odd situation. Let's say I have a domain group [DMN\Group] which has been created as a login on my server and a user in the database. One of the members in that group is not ...
1
vote
1answer
1k views
64 bit Postgres 9.1 Limitions on Windows 2008 R2?
When Deploying Postgres on Windows Server 2008 R2:
Are there any limitations on windows that don't exist on Linux?
Does the postgres scale in the same way on windows as it does on Linux?
Is ...
2
votes
2answers
230 views
Can I implement clustering with just 2 servers and one NAS?
I have the following architecture, it consists in only 2 servers, connected to a NAS.
I'm having trouble in implementing clustering because I can't have a domain controller in any of them (if I do ...
3
votes
1answer
686 views
How to find the detail cpu high process name which occupying most resource in the SQL Server database?
I'm running into a problem when using the following SQL to identify CPU usage in the production SQL Server 2005 env.
DECLARE @ts_now bigint;
SELECT @ts_now = cpu_ticks / CONVERT(float, ...
1
vote
2answers
2k views
How is localhost resolved by Oracle listener?
When I o an Oracle test installation on a Windows server accepting mostly the defaults, I end up with a listener.ora like
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = ...
3
votes
1answer
1k views
MySQL Workbench Database Sizes
I'm trying to find the total size on the hard disk that all of my MySQL Workbench databases are using.
Does anyone know of an easy way to figure this out?
If nothing else, the default location ...
4
votes
1answer
1k views
Windows Authentication for a non-local non-domain Login
I have SQL Server 2008 R2 installed on a Windows Server 2008 R2 box. There is no domain in the network.
Is there any way for me to add a Windows Login on SQL Server for a non-local and non-domain ...
3
votes
1answer
10k views
How do I grant all privileges to local db2admin with DB2 9.7 on Windows?
I have as my developer station a laptop with OS Windows XP Professional Edition, Service Pack 3.
I have downloaded and installed IBM DB2 UDB 9.7 fix pack 4, of the Express-C edition.
I have a local ...
0
votes
1answer
2k views
High PageIOLatch_SH Waits with High Drive Idle times
We are experiencing high volume of PageIOLatch_SH waits on our database (row counts in the Billions). However it seems that our drive Idle time Percentage hovers around 50-60 percent. CPU usage is ...
2
votes
1answer
273 views
PostgreSQL archive_command on Windows
What is the best method for WAL log transfer on Windows?
I have two servers with Windows Server 2008, PostgreSQL 9.0 64bit.
Servers do not have any shared SAN disk, they are on different hosts, ...
2
votes
1answer
286 views
Can I choose which CPUs / Cores to be used by MySQL?
I have a Windows VPS (Windows 2008 R2 x64) that runs a couple WordPress blogs and other few ASP.NET things. The VPS runs 2 CPUs (for example).
With ASP.NET, in such situation, I usually set the app ...
1
vote
1answer
155 views
Appropriate Windows version for Mysql
I have a HP ProLiant DL380 G5 server and I would like to install mysql on it .
My questions are:
Which MySQL version should I install from this link for better performance, 32 bit or 64 bit?
Which ...
1
vote
1answer
2k views
How to upgrade MySQL to newer version on existing database
I am having data of 20 GB with MySQL version 5.0.24.
Now I want to update MySQL to newer version 5.5.16.
We can do it by taking complete database backup and uninstall old MySQL and install new MySQL ...
1
vote
1answer
433 views
How to Prevent an Ever-Growing index file (MyISAM engine) From Causing Disk Fragmentation in Windows (NTFS partition)?
We have a keep-growing table which using MYISAM storage engine.
Almost every half year, this table will crash, and need to be repaired.
I checked the defragment result reported by windows ...
4
votes
1answer
455 views
How to restore a SQL Server 2008 R2 database
Here's my issue.
I have a server created from a windows image that includes SQL Server 2008 and two specific windows users, these windows users are a part of the sysadmin role and are users for the ...
2
votes
1answer
1k views
How do I create a database+tablespace+user in Oracle 11gR2?
Good evening,
I'm trying to figure out how to create a database+tablespace+user in Oracle 11g.
I've tried some tutorials, but nothing seems to work.
I cannot find Database Configuration Assistant ...
2
votes
2answers
4k views
How to start Oracle database's listener service after a change in the IP address?
I'm using Windows XP as my Oracle database server. Today there was a change in the IP address if the database server.
I want start my database instance's listener again. Windows XP prompst that:
...
2
votes
3answers
3k views
What's a good (free) client for Informix on Windows? [closed]
I'm looking for a GUI client for Informix on Windows (mainly to view data and execute queries), free would obviously be nice but I know Informix is used mostly in corporate environments and free may ...
4
votes
1answer
65 views
Internals of Windows-to-Windows SQL Server data transfer
This is a sort of generic question and I don't require a very specific answer, but let me ask it by describing a scenario.
You connect to a remote db in SQL Server Studio 08, and run a select * ...
2
votes
1answer
73 views
Bad Windows Authentication sign on
I do not have install privileges on my machine.
Another user who has admin privileges installed it, but told the system to use Windows Authentication for the sign on.
Is there a way they can change ...
3
votes
1answer
675 views
oracle failsafe - how to start instance in nomount
Using Oracle Failsafe, how can a instance be started up in nomount mode?
If the instance is shutdown via sqlplus, the windows cluster manager just starts it up again. If the instance is shutdown via ...
3
votes
2answers
408 views
How much RAM I should assign to SQL Server 2008 running on W2K3
I'm planning an installation for SQL 2008 over Windows 2003. The server has 16g RAM. How much RAM I should assign to SQL server?
3
votes
2answers
332 views
Testing Query Speed
When I'm running a query for the first time, it takes x miliseconds to be executed. When I run it the second time it takes a lot less time. I assume that it is some caching involved in this mechanism, ...
