Should The Quorum Disk Be A Physical Disk Or Majority Node Set?
Hello,
I am trying to setup a test cluster and am having an issue. When I try to create the resource of a physical disk it takes both the drive e: and drive q: and doesn't seperate them into two physical disks as resources. This means when I try to associate the quorum disk it links the to physcial disk resource of drive e and q. Then when I try to install SQL2k5 I get the warning about installing SQL on the quorum disk. Am I missing something? Is there a way to seperate e and q onto two physical disk resources so I can specifically associate the quorum to q and the sql to e or should I be setting the quorum disk to a majority node set? Thanks in advance.
John
View Complete Forum Thread with Replies
Related Forum Messages:
Calculating COUNTER Physical Disk: AVG. DISK QUEUE LENGTH
If I return the Average, Minimum, and Maximum values for the counter Physical Disk: Avg. Disk Queue Length, and those values are 10, 0, 87 respectively, which value do I use to compute the Avg. Disk Queue Length for a 4 disk array(RAID 10): Average, Minimum, or Maximum? The disk(lun) is on a SAN.
View Replies !
Quorum Disk Again.
Hi, I'm trying to install a server cluster to implement an SQL Server 2005 cluster. No other services (I think this is important). I've a dual SCSI channel Smart Array with 4 disks configured in a 400Gb RAID 5. I do not need to move different resource groups from one node to the other, I need only one group with all the resources IP, Network name, MSDTC, and SQL Server..., when a node fails, all services should failover to the other node. Is it possible to have only one physical disk (RAID 5) for Quorum disk and shared disk? It would be the following configuration: [Groups] Cluster Group IP Address Network Name Physical disk (used for quorum and shared storage) Distributed Transaction Coordinator SQL Server SQL Server Agent Generic Service (SQL Server Fulltext) The other option would be having a 1 physical disk Raid 0 for Quorum (146Gb wasted) and another physical disk Raid 5 (3 disk) for Shared Storage, but this schema will have a a flaw point that if Quorum disk fails, the cluster fails.... Any help would be appreciate. Best regards. Ilde.
View Replies !
Disk Quorum Full
Dear All, I've the quorum disk of my cluster on win2003 full and I cannot use The cluster administrator because the Service Cluster cannot going up. Obviously the shared disk (included Quorum) and MSDTC are not visible and I'm wondering if is possible to solve the problem without rebuild the cluster. Thank you to everybody
View Replies !
Quorum Disk - Clustering SQL 2005
Dear All, I am trying to setup clustering for SQL 2005. I initially want to setup a 2 node cluster in Active/Active Configuration. I am trying to understand the Quorum disk in SQL 2005. As I understand the quorum disk is a shared resource. How is this resource configured? Would I need to have an iSCSI or fibrechannel connection from each of the nodes to the shared disk? As well, does each node have a separate data drive? Or do all the nodes use only the shared storage? Thank you.
View Replies !
Is It Possible To Move My Sql 2000 Database (in C Disk) To Another Disk (Disk) ?
hello,all I am new to Sql 2000,I installed sql 2000 database in C disk,but Now I found my C disk space is smaller than before,So I want to move my databse(include data and structure) from C Disk to D Disk(its space is very large) . is it possible to do it ? if its can be done ,do I need to change my asp.net program source code (exp: chaneg my crystal report connectstring ) ? thanks in advanced!
View Replies !
SQL 6.5 And SQL 7 Instaled On The Same Physical Disk
Hi! I have SQL Server 6.5 and SQL Server 7.0 instaled on the same physical disk. Now I want to get rid of SQL Server 6.5. Did somebody have situation like mine and tried to uninstall SQL Server 6.5. What kind of problems have you had? How can I avoid them? What kind of impact can be on NT registry? Please share your experience. Thank you, Anny
View Replies !
Physical Disk Partitions
I just inherited a dev box, and need to do some performance analyzing on a 40 gig db for a client. Time is of the essence! My question is that this dev box only has one disk partition (c: drive). Is it a huge deal that I don't have the db system files on one drive, with the data files on another, and tempdb on another,etc.....
View Replies !
Trying To Recover Physical Disk Space.
My SQL Server databases grew large. I deleted un-needed data from somedatabases. I then ran a stored proc that re-indexed the entire db. Mydatabase was 1.1 gig no the properties says it's 292 mb after I ranshrink database. I have a few other dbs I reduced in size. My physicalhard drive is 57% fragmented as reported by Disk defragmentor utility onmy Win 2k Adv Serv SP 4 server. I ran the defragmentor several timesand I'm unable to make any improvement. I also ran degfrag afterstopping all my IIS, SQL Server, and NetMeeting services. I still hadsome other services running.I want to defrag my physical mirrored disk volume.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View Replies !
Moving A Database To Another Physical Disk
I want to move 2 databases to another physical disk. They are both single file databases. It looks like a fairly straigtforward attach and detach procedure, but I have a couple of questions: The log files (.ldf) currently reside on a separate physical disk from the data files, if I attach and reattach the data files will the logs remain where they are by default or do I have to re specify there location? Is there any advantage to running the update statistics portion of the sp_detach_db?
View Replies !
Weird Physical Disk Access
Hi, I have an MS SQL 2000 server running on a Proliat with two CPUs and 2GB RAM (the process actually uses 1.6GB). For some reason, the same queries (which return the same data) run sometimes very fast and sometimes very slow. I used the performance counter to find out that when the queries run fast there is little disk i/o and when they run slowly there is a lot of i/o. I thought it happens because the DB keeps swapping tables in and out of RAM. The problem is that these things happen in periods. I can have a few hours of slow access and then a few hours of fast access. This makes me believe that it doesn't actually put the table in the cache untill it is requested enough times. Very weird. HELP? Thanks.
View Replies !
Move Log File To Another Physical Disk
Hi everyone, Due to running out of disk space and reducing I/O contention, I plan to seperate data files and log files to different disk arrays. My plan is to - detach all databases - copy log files to another disk - attach all databases The total size of log files is about 60GB. It becomes a problem becasue it spend too much time passing files. To reduce down time, is there any way I can do? Can I just create new log files and remove the current files by using sql management studio? any other suggestions? Thanks in advance
View Replies !
Get Total Disk Size And Free Disk Space
-- Initialize Control Mechanism DECLARE@Drive TINYINT, @SQL VARCHAR(100) SET@Drive = 97 -- Setup Staging Area DECLARE@Drives TABLE ( Drive CHAR(1), Info VARCHAR(80) ) WHILE @Drive <= 122 BEGIN SET@SQL = 'EXEC XP_CMDSHELL ''fsutil volume diskfree ' + CHAR(@Drive) + ':''' INSERT@Drives ( Info ) EXEC(@SQL) UPDATE@Drives SETDrive = CHAR(@Drive) WHEREDrive IS NULL SET@Drive = @Drive + 1 END -- Show the expected output SELECTDrive, SUM(CASE WHEN Info LIKE 'Total # of bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS TotalBytes, SUM(CASE WHEN Info LIKE 'Total # of free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS FreeBytes, SUM(CASE WHEN Info LIKE 'Total # of avail free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS AvailFreeBytes FROM( SELECTDrive, Info FROM@Drives WHEREInfo LIKE 'Total # of %' ) AS d GROUP BYDrive ORDER BYDrive E 12°55'05.25" N 56°04'39.16"
View Replies !
SQL Server, Disk Arrays And Disk IO
Hi all, Ok here goes, I have a three tier system using SQL server 2000, we are currently experiencing IO bottle necks on our SCSI Raid 10 array, which holds the Data and the logs in separate partitions. So my options as I understand it are: Get Enterprise edition or Get another physical raid 10 array and separate the logs and data i.e. data on one array and logs on the other array. I would like to try the latter but I am totally unsure how much difference this will make or whether it will make any difference at all. Does anyone know how much performance increase I will get from using two arrays as opposed to one? Any other advice on this scenario would be greatly appreciated. Thanks
View Replies !
Majority Node Set Sql Server Clustering And Log Shipping
Hi!Folks We are in a process of doing majority node set clustering since our cluster object is for geographically dispersed clustering. I have 3 nodes .On two nodes I have installed cluster services ..created a majority node set resource and now I am with the 3rd server. I am wonder ing whether I have to install MSCS to the third node also. as the white paper published bu MS have not mentioned much abt the 3rd node.I need to set up log shipping on this node.If any one have any idea on this please suggest me.
View Replies !
SQL 2005 Analysis Service Clustering And Majority Node Set
Hi, I am trying to set up a SQL 2005 analysis server cluster in our two servers, AS02 and AS04. The server cluster is built up on Majority Node Set (MNS). During the installation of the analysis service, I don't see the available cluster groups. In the cluster admin, the cluster is up and running fine. The MNS cluster has no shared disk, and it has two nodes. Any thoughts or suggestions? or is it possible to built the SQL 2005 analysis service cluster with MNS? Thanks.
View Replies !
Disk To Disk Backups
Does anybody know exactly what happens within the SQL Server engine when backups are done? Specifically is tempdb used as a 'staging post' to write data to before it is written out to the backup directory? The reason I ask is that during weekend, full database backups one of the stripe sets in my RAID array (there are 8 in total) is being hit VERY hard. I am trying to identify what is happening, hence the question. If anyone has any thoughts or suggestions they would be gratefully accepted. Jonathan
View Replies !
DIsk Quotas
Hello,I am investigating setting up a shared sql server. I wish to enforcedatabase size quotas, and hopefully still allow customers to managethe creation of their own databases.Any thoughts or suggestions would be appreciated.Kind RegardsSimon Hall
View Replies !
Low Disk Space On C:
I noticed something strange today. I was running a query using query analyzer on a large database (8.8 million records) and the disk space on the c: drive was dropping and eventually went to 0. Availalbe space on the c: drive is 10GB. The query did complete. SQL server and all the databases are on the d: drive. After closing the query results in query analyzer the disk space returned. Is this a concern and is there a way to change it to use the d: for whatever it is doing?
View Replies !
Disk Fragmentation
What's the best way to find out if disk fragmentation on Windows 2000 Server is affecting SQL Server performance? If disk fragmentation is shown to be a cause of performance problems, what are the recommendations for a disk fragmentation strategy? eg. use the win 2000 built in disk defrag utility or buy a 3rd party product like DiskKeeper? How much of an overhead is a product like DiskKeeper that defrags in the background? Clive
View Replies !
Disk Full.
Hi all, I have a problem... I use SQL server 2000,all the disk on computer is used to store data file and transaction log file, and now they are full so data can be insert or update because the data file and transaction log file can be add more or increase, please show me. Best regard,
View Replies !
SQL 6.5 And Disk Cloning
We need a drive cloning app, like Ghost, that will allow us to transfer a production image off of a HDD to other PCs. The problem with this is that our production needs SQL in order to run and transferring the initial image to uniquely named workstations causes DB registration problems. Is there an app that will allow us to configure this transferred image so that SQL will refer to the "new" drive instead in of the "old"?
View Replies !
DB Disk Space
In a fast growing OLTP database, disk space is critical. What, if any is the connection between the unallocated and unused space fields in sp_spaceused proceedure? Can unused table space really be reclaimed by the general database?
View Replies !
Disk Keeper
Dear All, How are you? NT 4.0 with Service Pack 5, SQL 6.5 with service pack SP5A. Should I run Disk Keeper after stopping the SQL services for Disk Defragmentation? You know the data always is important. Please correct me if I am wrong: "We can't even copy or compress the SQL DAT files while the SQL services are running." Thanks in Advance!!!!!!! Kind Regards SaDaT
View Replies !
High Disk I/o
Hello, We are experiencing high disk i/o on one of our RAID disk systems. Can someone tell me how I can identify the query or user or process which is causing this high disk i/o? Thanks, Brent.
View Replies !
Disk Space
Does anyone know how to get the free disk space for all drives in many different SQL servers. I need to populate a report (right now output in Excel) with the free disk space of all drives on all of my SQL servers. I found xp_fixeddrives but that is specific for the server where it is executed. Any help or pointers to a script in the archives is much appreciated. Thanks.
View Replies !
Disk Fragmentation && SQL
One of my production servers has been determined to be 92% fragmented. What's the proper procedure for defraging a database server? I couldn't find anything very helpful in BOL, nor Knowledge Base. Sidney Ives Database Administrator Sentara Healthcare
View Replies !
Disk Space
Hello I need to setup a compaq sever with 300 MB database, and will be adding around 600 records on a daily basis. Can someone help with how much disk space i should have on sqlserver, providing i have c: and d: setup. Thank you in advance for all the help. Paula
View Replies !
Disk Space
Hi All, I have a server and it has C: D: F: I: Drives and all the system files are on C:Drive and and all the .MDF's and .LDF's(model,temp,master) are on the F: Drive and now I am running out of space on both(C: and F: Drives) 1. Can we add space to the C: and F: drives on the fly?. 2. Can I move the System databases ( MDF's and LDF's to some other drive)and if so, how do I do it?( Moving the databases ) and this is on the production database so when I have to do this.Will there be any impact. Thanks in Advance, Reddy
View Replies !
Move Log To Different Disk
We will move t-log from one disk to another one. I tried Alter Database and found it did not work for log. Can somebody give me a method about moving log from different disks? Thanks. Jean
View Replies !
Normal Disk IO
I am wondering what normal disk I/O should be. i know it verys depending on use but im looking for an average. here is an idea of what we have there is about 10 centers doing replication to our primary server. we have about 80 users connecting directoy to our primary server using MS Dynamics through CITRIX. we have a few other apps use the database as well however i am fairly certin its Dynamics generating our disk IO Hardware wise we have a powerful blade connected to a raid 5 SAN with 15000 rpm disks. normaly the disk IO stays fairly low but every so often it goes crazy and im thinking it shouldn't Below is a sample of our disk IO from perfmon over 2 minutes or so. as you can see everything looks ok untill 04/15/2008 10:12:49.470 when the Disk I/O % goes above 100% "04/15/2008 10:12:23.470","2.8300181121159178" "04/15/2008 10:12:24.470","0" "04/15/2008 10:12:25.470","3.950025280161793" "04/15/2008 10:12:26.470","0" "04/15/2008 10:12:27.470","0" "04/15/2008 10:12:28.470","5.9800382722449426" "04/15/2008 10:12:29.470","7.7400495363170325" "04/15/2008 10:12:30.470","3.4500220801413128" "04/15/2008 10:12:31.470","0" "04/15/2008 10:12:32.470","4.180026752171214" "04/15/2008 10:12:33.470","3.8600247041581071" "04/15/2008 10:12:34.470","0" "04/15/2008 10:12:35.470","142.71091334984544" "04/15/2008 10:12:36.470","0" "04/15/2008 10:12:37.470","1.1500073600471041" "04/15/2008 10:12:38.470","0.81000518403317789" "04/15/2008 10:12:39.470","0" "04/15/2008 10:12:40.470","2.1400136960876548" "04/15/2008 10:12:41.470","10.230065472419025" "04/15/2008 10:12:42.470","4.5800293121875981" "04/15/2008 10:12:43.470","0" "04/15/2008 10:12:44.470","0" "04/15/2008 10:12:45.470","14.500092800593926" "04/15/2008 10:12:46.470","6.730043072275663" "04/15/2008 10:12:47.470","1.6300104320667652" "04/15/2008 10:12:48.470","7.3500470403010585" "04/15/2008 10:12:49.470","264.66169383484055" "04/15/2008 10:12:50.470","324.18207476527851" "04/15/2008 10:12:51.470","536.17343150996169" "04/15/2008 10:12:52.470","270.31172999507197" "04/15/2008 10:12:53.470","331.97212462159757" "04/15/2008 10:12:54.470","333.84213658967417" "04/15/2008 10:12:55.470","435.57278766584108" "04/15/2008 10:12:56.470","442.31283080211716" "04/15/2008 10:12:57.470","685.92438991609549" "04/15/2008 10:12:58.470","295.1618890360898" "04/15/2008 10:12:59.470","61.470393410517829" "04/15/2008 10:13:00.470","56.360360706308519" "04/15/2008 10:13:01.470","45.260289665853861" "04/15/2008 10:13:02.470","224.58143732119885" "04/15/2008 10:13:03.470","1022.0365410338626" "04/15/2008 10:13:04.470","1114.6271336136551" "04/15/2008 10:13:05.470","241.52154573789269" "04/15/2008 10:13:06.470","506.79324347675828" "04/15/2008 10:13:07.470","374.88239924735518" "04/15/2008 10:13:08.470","359.5723012627281" "04/15/2008 10:13:09.485","427.62119831413077" "04/15/2008 10:13:10.485","400.15256097639025" "04/15/2008 10:13:11.485","1076.2868882360847" "04/15/2008 10:13:12.485","325.94208602935055" "04/15/2008 10:13:13.485","449.36287592240592" "04/15/2008 10:13:14.485","344.28220340610181" "04/15/2008 10:13:15.485","569.57364527132972" "04/15/2008 10:13:16.485","775.02496015974498" "04/15/2008 10:13:17.485","729.54466908588222" "04/15/2008 10:13:18.485","778.70498371189581" "04/15/2008 10:13:19.485","1080.1269128122422" "04/15/2008 10:13:20.485","754.56482921490704" "04/15/2008 10:13:21.485","999.11639434492372" "04/15/2008 10:13:22.485","701.36448873272786" "04/15/2008 10:13:23.485","276.26176807531567" "04/15/2008 10:13:24.485","252.13161364232732" "04/15/2008 10:13:25.485","533.27341294984296" "04/15/2008 10:13:26.485","759.54486108711092" "04/15/2008 10:13:27.485","817.11522953746908" "04/15/2008 10:13:28.485","129.41082822930068" "04/15/2008 10:13:29.485","158.94101722251023" "04/15/2008 10:13:30.485","160.55102752657618" "04/15/2008 10:13:31.485","655.87419759486454" "04/15/2008 10:13:32.485","444.49284475420637" "04/15/2008 10:13:33.485","272.47174381916045" "04/15/2008 10:13:34.485","94.730606275880163" "04/15/2008 10:13:35.485","355.28227380655238" "04/15/2008 10:13:36.485","898.29574909279427" "04/15/2008 10:13:37.485","1309.3783800216322" "04/15/2008 10:13:38.485","88.200564483612695" "04/15/2008 10:13:39.485","1.2300078720503811" "04/15/2008 10:13:40.485","4.9400316162023437" "04/15/2008 10:13:41.485","217.90139456892524" "04/15/2008 10:13:42.485","373.26238887928884" "04/15/2008 10:13:43.485","73.760472067021226" "04/15/2008 10:13:44.485","1.4100090240577541" "04/15/2008 10:13:45.485","34.960223745431975" "04/15/2008 10:13:46.485","15.990102336654955" "04/15/2008 10:13:47.485","63.580406914604247" "04/15/2008 10:13:48.485","26.560169985087906" "04/15/2008 10:13:49.485","11.150071360456707" "04/15/2008 10:13:50.485","15.250097600624644" "04/15/2008 10:13:51.485","17.010108864696736" "04/15/2008 10:13:52.485","12.210078144500125" "04/15/2008 10:13:53.485","95.650612163917842" "04/15/2008 10:13:54.485","38.740247937586801" "04/15/2008 10:13:55.485","5.6000358402293777" "04/15/2008 10:13:56.485","1.6600106240679942" "04/15/2008 10:13:57.485","19.590125376802412" "04/15/2008 10:13:58.485","2.8100179841150981" "04/15/2008 10:13:59.485","631.48404149786563" "04/15/2008 10:14:00.485","579.14370651972172" "04/15/2008 10:14:01.485","1.0600067840434177" "04/15/2008 10:14:02.485","15.870101568650039" "04/15/2008 10:14:03.485","112.28071859659903" "04/15/2008 10:14:04.485","15.660100224641438" "04/15/2008 10:14:05.485","4.9800318722039822" "04/15/2008 10:14:06.485","25.44016281704203" "04/15/2008 10:14:07.485","16.130103232660691" "04/15/2008 10:14:08.485","5.9300379522428939" "04/15/2008 10:14:09.485","4.8400309761982481" "04/15/2008 10:14:10.485","2.6400168961081349" "04/15/2008 10:14:11.485","19.430124352795858" "04/15/2008 10:14:12.485","42.55027232174286" "04/15/2008 10:14:13.485","37.550240321538055" "04/15/2008 10:14:14.485","1.210007744049562" "04/15/2008 10:14:15.485","15.930101952652498" "04/15/2008 10:14:16.485","20.550131520841735" "04/15/2008 10:14:17.485","4.0900261761675267" "04/15/2008 10:14:18.485","8.0100512643280908" "04/15/2008 10:14:19.485","1.6000102400655365" "04/15/2008 10:14:20.485","2.3300149120954372" "04/15/2008 10:14:21.485","1.6200103680663558" "04/15/2008 10:14:22.485","10.730068672439504" "04/15/2008 10:14:23.485","4.4600285441826832" "04/15/2008 10:14:24.485","9.0300577923698704" "04/15/2008 10:14:25.485","0" "04/15/2008 10:14:26.485","15.550099520636932" "04/15/2008 10:14:27.485","2.970019008121652" "04/15/2008 10:14:28.485","64.580413314645213" "04/15/2008 10:14:29.485","71.850459842942996" "04/15/2008 10:14:30.485","53.220340610179903" "04/15/2008 10:14:31.485","32.620208769336124" "04/15/2008 10:14:32.485","1.0000064000409603" "04/15/2008 10:14:33.485","4.8400309761982481" "04/15/2008 10:14:34.485","8.2700529283387425" "04/15/2008 10:14:35.485","11.160071424457115"
View Replies !
DTS Disk Space
This is my first attempt using SQL 2000 and DTS. I am importing an Access database using the DTS wizard. The process fails with a "Not enough space on temporary disk" error. There is definitely enough space on the physical disk. I don't have any limits on any folder sizes either. What "disk" is the error talking about, and how do I give it enough space. The database is relatively small, about 10MB. I believe the database was created using Access 97. Please help.
View Replies !
Disk Organization
I understand the log files (LDF ) and data files (mdf ) should be on a different drives . I believe it leads to greater availabilty and speed . Are there any other reasons for to keep this on a separate drive. Also what considerations I should take care while creating a database of around 100 GB . (use of filegroups , growth % etc ). Is there any connection of number of users to number of disks SQL data file to be spread to . Also do I need to take care (through hardware / software for a Quad core CPU ) to take full advanage of Quad core CPU.
View Replies !
Recovery From LOG Disk Failure
I am writing up a general purpose document regarding Disaster Recovery and Backup and Restore, etc. I have a question that I've been unable to find any definitive answer on, and I was hoping that someone might have an answer. Here is the scenario and what I have so far, and my question: Scenario - A simple database, with one MDF and one LDF, each on it's own disk, with no mirroring or filegroups etc. Disaster - the LOG disk fails. To simulate the disaster, I shut down SQL Server, and delete the LDF manually. When I restart SQL Server, the database is marked as suspect. As expected :) So, now the recovery begins..... I've read that in this case there is no data loss, but I find that hard to believe. Can anyone confirm? Anyway, how to restore the database to usable status? Here is what I've come up with so far: 1) Do a backup of "the tail of the log." This works even though there is no log. I have no idea why really, but I can't proceed otherwise. 2) Detach the database. 3) Reattach the database. This auto-creates a new log file (albeit not in the location I want, which makes for more work after). At this point the database appears to be fine. I have not seen any lost data or problems, but of course I'm working on a test database, not with live users hitting it constantly. If the database were under heavy use, I expect that there might indeed be data lost? Is this the recommended way to recover from a disaster of this type? Or, would it be better to just go back to your last good backups and forget about "up to the minute" recovery in this case? Or is there yet another means? Thanks, Travis
View Replies !
Disk Or Network Error
HiI have written an application in VB through which I can convert DBASEIV database to MS SQL Server database. Also, the application providesdatabase manipulation features to the user like addition, deletion etcof records.I am using OPENROWSET for conversion purposes. Also the server is MSSQL Server 2000.Now this application workks fine when I have installed the instance ofMS SQL Server on my local machine. It converts the database and storesit on the server perfectly and there are no isues.However, when I try to use the application to connect with MS SQLServer on another machine, there are a few problems. I connect to theother MS SQL Server on other machine through named pipes. Myapplication successfully accesses the database and allows user tomodify it according to his needs.For this I created the user account of that user on the machine.But when I try to convert the database, I get the following errormessage:[Microsoft ODBC Dbase driver]Disk or Network ErrorHere is the line in VB code which is causing all the trouble:con.Execute "select * into " & UCase(X) & " fromOPENROWSET('MSDASQL','Driver={Microsoft dBASE Driver(*.dbf)};DEFAULTDIR=" & BaseData & ";SourceType=DBF','select * from " &UCase(X) & "')"Here, X is the dbf file name, BaseData is the path name of file.I gave the user full rights but i am still getting this error message.Now, what am I doing wrong here?Regards,Shwetabh
View Replies !
Timeouts - Disk Queues
HiGot a strange problem.For some reason our web client box times out occasionally. Maybe afew times a day.Nothing appears in the logs.What I do know is that the disk queue ramps up to <high>(think top ofthe graph), processor queue jumps up and the tps drops to 0 (naturallyenough!) along with reduced pagefile usage. Usually at this time thetps is between 20 and 300. Running a pair of mirrored 18gb scsi disksfor the whole server (yeah yeah) and a whopping 640mb memory. Oh anda single piii 1 gig. Sql2k standard vanilla, server2k.What server trace events is it worth my catching to try and get abetter Idea of what may be causing this? No major jobs (backups etcseem to be occuring at these times).Cheers
View Replies !
Logging To Second Disk -- What Happens When It Crashes?
Currently we have SQL Server running on a single RAID5 array.The data and the logs are all written to this array. We don'thave huge volume of activity, but it is growing. Most activityis from our website that interacts a lot with the database.We have read that it is a good idea to separate the data filesfrom the log files, having each on separate disks (or in thecase of RAID, separate arrays). So, we are considering addinga separate SCSI hard drive, or maybe a RAID 1 system, and havesql server log to that instead.My question is, what happens if that secondary drive or arraycompletely fails. Let's say it melts. Assuming the OS doesn'tcrash (Windows 2003 Server), what will SQL Server 2000 do whenthe drive stops working and it is trying to write its datalogging to it? Will it continue to function and write alertevents? Will it shutdown? If it shuts down, how do we alter itsconfiguration to tell it to use another drive for the logs?Also, what kind of throughput would we need to be doing to seeany kind of benefit to making this change? It is easier tojustify the expense of another disk or RAID setup if it isactually going to matter. ;-)Thanks all!Thomas
View Replies !
Saving Disk Usage
I import about six 30,000-line text files to my database daily using a few DTS's - is there a way to "turn off" the transaction log for these imports to conserve disk space? I do not need to log these inserts... Thanks.
View Replies !
Perfmon Disk Counter
May be I just lazy! (not refering to manual) Does anyone know the "Disk second per transfer" in Perfmon include queuing time as well? I have a measurement of 30ms per transfer. Is this figure include the queuing time in Windows or is it just the plain service time of the disks? Thanks in advance.
View Replies !
Obtaining Disk Space
Hi, I'm new to these forums (and to SQL Server), so please be gentle with me. I am developing a process to obtain information on all our remote servers/databases, and store it in a single local database. I'm after things like db size, last backup date, free drive space etc...the usual weekly statistics. I've linked the remote servers to my local one, and have written a few simple procedures (which exist on the local server) to grab backup and file size information from the remote tables. The output is stored locally in tables which we can then query as necessary. I am having difficulty obtaining the free drive space details. I'm using :- 'exec <remote_server>.master.dbo.xp_fixeddrives' to get the info, but I cannot store the output in a table on the local server. (remote_server_name, date, drive_letter, space_mb) I wish to avoid creating any objects on the remote servers if at all possible. I really want to pass the remote server name into the procedure, and the output to be inserted into the table. Many thanks
View Replies !
RAID1 Vs 3-disk RAID5 For DB
I'm making whatever hardware upgrades I can very easily do on this box. Due to only having 6 HDD slots in my IBM x235 tower's backplane, I can't have 3 volumes AND have one of them as RAID 5. Also; a 3 volume RAID 5 just seems silly. Wouldn't it have worse performance than mirrored (both read and write)? Well; I don't claim any knowledge on all this so should stop on the wild guesses. My DB is 3GB (+ 2GB log file). It's looking like it may grow up to 5 or 10 GB per year on the very outside, so 140GB for DB should be plenty for years to come. I just want to keep this upgrade small and simple with zero exposure to upgrade heartache and regret. Therefore; I plan to avoid an O/S or Software rebuild. My hardware / network guy says upgrading the O/S drive from 10K RPM to a larger 15K RPM drive requires OS reload. He's not entirely sure since he's never done it using this IBM RAID card, but 10K RPM should be fine for the O/S. Existing: Internal IBM PCI RAID Controller (not sure model, but decent). All RAID is via hardware controller. Volume 1 = 10K RPM mirrored SCSI. Volume 2 = 10K RPM RAID5 with 3 volumes Slot 6 empty. Solution 1: 1. 2 volume solution that includes a small RAID 5. Volume 1 = 10K RPM RAID1 SCSI. (O/S, Log, and DB Backup files) Volume 2 = 15K RPM RAID6 or RAID5 with 4 disks 2. 3 volume solution Volume 1 = 10K RPM RAID1 SCSI. (O/S only) Volume 2 = 15K RPM RAID1 SCSI (for DB only) Volume 3 = 15K RPM RAID1 SCSI (for Log files only) I have heard it's better to have log files on a mirrored disk because the I/O tends to be write intensive and contiguous. I don't know how intensive DB I/O is vs. Log File I/O vs. OS I/O. Maybe someone who does could advise me in this matter. Additional question: Are higher capacity HDDs faster for read/write? Say; comparing 32GB vs. 300GB, the 300GB must be more compressed, so more data would travel over the heads. Yet; the specs don't seem to imply that there's much difference (unless I'm missing something). Thanks!
View Replies !
|
TRACKER
