Tag Info

Hot answers tagged

3

Looking at the sysmon, you're attempting to do 964.2 IOPS, Total Requested Disk I/Os 964.2 2373.5 2314183 of these 99.2% are accounted for by this device, all your other devices are doing very little. All you devices are on the same physical array (D:), but this isn't a problem if they're doing nothing. Device: ...


2

We use a workaround: Execute with administrative rights and enable compatibilty with "Windows Vista Service Pack 2".


2

it looks to me like your actual Avg disk queue length is 3.554. The scale is set to graph it at 100x the value. typical indications of issues start when this number is greater than the number of spindles in the raid group. i would start with procmon from sysinternals to start determining the disk usage. i would then look into db specfic tools to monitor ...


2

quiescing a database suspends updates to the database. Essentially making sure nothing happens to the data data while you're dumping or doing some other action. Note: "hold_tag" can be any string you choose. From isql (or whatever you use to connect to the db), just run (as sa, or equivalent) quiesce database hold_tag hold database, database, etc To ...


2

sp_helpconfig "row lock promotion" At server level. or sp_help table_name Should do the job on table level. See this link as a example.


2

We proofed this exact scenario within the last two months here. This is an overview of what we did. Solaris [ 1 ] We are running Sybase IQ 15.2 on raw devices. [ 2 ] All Luns on Solaris X86 system were created with an fdisk and Solaris EFI vtoc label. The SAN was a Clariion CX4 : fdisk -W - /dev/rdsk/c3t600601604E402D002C5763C4D3F8E011d0p0 ...


1

when you say "raw devices", are you talking "raw devices" or "raw partitions"? raw devices will just work. if you're using raw partitions, then if the disk format is something that linux can understand (GPT, MBR, etc.) you're fine. depending on the capabilities of your SAN, you could take a snapshot and mount the snapshot on a linux box to test with.


1

Your research is absolutley correct. Once you allocate device space to a database, you can't claim that space back. The only way to get disk space back is to drop the database, and the associated data devices. To get the necessary database objects from the database if you don't already have them is to use the ddlgen utility. This will reverse engineer the ...


1

reorg rebuild Tweak space management settings before the rebuild if needed. When reorg rebuild rebuilds a table, it rewrites all table and index rows according to the table’s current settings for reservepagegap, fillfactor, and exp_row_size. These properties all affect how quickly inserts cause a table to become fragmented, as measured by a low cluster ...


1

This question is old, but I'll answer anyway. Sybase Open Client is licensed per-seat and they don't provide download access to software without a valid support identifier. There's an implementation called FreeTDS which is available for Unix/Linux and jTDS which is a Java implementation. I believe the latter works on Windows (although I haven't used it).


1

Disclosure: I work in SQL Anywhere engineering. You are correct - to connect to a SQL anywhere database, you need to provide a username / password recognized by that database. When a database is created, a user called "dba" is created with a password of "sql", but users are free (and encouraged!) to change this password. You can even drop the "dba" user if ...


1

I'd expect sequential IO to be faster than what you are seeing but sustained 4K 100% random write IO would be around 500-600IOPS for that set up [assuming 14 active disks, 10K SAS, RAID 50] so the question I'd be asking is how are you sure that the IO pattern on the volume really is sequential? What other volumes are being presented by the PS600X and what ...


1

Try adding the go in the result: select 'exec uspd_thing "'||name||'"'||char(10)||'go'||char(10) from sometable


1

Are you sure you're actually running 64 bit Linux? Try checking uname -m. If you have libaio-0.3.105-2 (i386), don't use -0.3.102 (x86_64). Grab the proper RPM from a CentOS mirror if you don't have access to up2date. The libraries can coexist. Edit: SRPMs are usually rpmbuild -bb. make isn't typically required. Building the SRPM will give you a ...


1

One thing I did in the past was to use a 3rd party tool (couldn't quite get the Microsoft Data Transformation Service to do this) - for example RazorSQL (http://www.razorsql.com). There's a 30 day trial on it and you can use it in order to connect to the Sybase db server and dump all of the tables into CSV files. You can then bulk insert those files into ...


1

Check your objects with sp_help table_name And sp_helpindex table_name Both will inform you about the status of an index.


1

Sybase DBA must read: Sybook http://infocenter.sybase.com/help/index.jsp http://sypron.nl/ http://rocket99.com/sybase/


1

Sybase replication server can replicate between Sybase, MS SQL, Oracle and DB2. It doesn't look like it can do MYSQL. http://www.sybase.com/products/businesscontinuity/replicationserver/heterogeneousreplication


1

No, the Sybase replication server only works between Sybase instances. Golden Gate software has an excellent solution for real time inter-database replication. You can set it up to bi-replicate, so that changes on each side are propagated. http://www.goldengate.com


1

If the DBs are on their own partitions, df -h will return the information under *nix. If they're in their own directories, you can run du -hS. Not sure how you'd do it inside Sybase itself, though.



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