| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9
Comments:
<0> i'm out. later
<1> I have performance issues on a sql server that just started recently. Only things changed on the box was the install of computer ***ociates backup exec 11.5. The database itself however is relatively young, a few months old. It is a datawarehouse of sorts. I'm worried that autogrow settings on the dbs may be causing file fragmentation. I'm just looking for some guidance, or maybe some pointers on how to determine where this problems are originating fr
<1> Database is MSSQL
<1> oh woops
<1> I'm getting ignored anyway it seems =)
<2> run a backup, your transaction log is probably huge
<3> hey, why is this happening?
<3> (mysql)
<3> #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'kat2 TO kat' at line 1
<3> query was: RENAME kat2 TO kat;
<4> topic
<3> uhh
<1> is 42 megs a large transaction log?
<5> Blackie: How large is the DB?
<1> 701
<5> 701GB?
<1> sorry
<1> megs +)
<4> haha
<1> err =)
<5> oh, tiny little thing then
<1> yup
<1> it's a small business =)
<5> Probably more indexing and schema than anything else.
<1> well the schema is good
<1> the indexing has been working fine
<1> I mean I have had awesome performance up to this point
<1> the db grows by a fraction of a percent daily
<1> as it mirrors records from another data source
<1> I run an index defrag on a weekly basis because one of the tables is rebuilt from scratch nightly and I was concerned that it's indexes were getting hosed everytime, especially because I truncate the table.. which as I understand it doesn't clean up after itself
<1> My symptoms are timeout errors trying to connect to the datasource from crystal reports etc... HYT00, S1T00 sqlstates
<2> sounds more like a network issue
<6> ok, what are some concerns and issues I need to look ahead too when installing WinXP SP2 ... on a box that's been running SP1 the whole time ...
<1> yeah that's what i Thought too but I can ping the box with tcpip, or hostname, I can telnet to the sql server on that port
<1> connect, etc
<6> does SP2 still auto-enable a bunch of bogus security rules and **** ?
<1> yes
<1> it does zoul
<2> sp2 is not very invasive
<6> windows firewall, ie security zones, etc ... anything else ?
<2> if you dont like it just disable the damned firewall
<1> yup
<7> actually i'm seeing similar mssql timeouts on a customers db server :)
<6> CoJoNEsX, yeah i know ... I just need to know what to disable, lol ...
<1> yeah billy?
<6> the network I'm on is designed for SP1 ... and SP2 causes issues ... but I need SP2 for .NET 2.0 ;)
<2> what kinda issues?
<7> it's got 4GB memory, and everything used to be perfect, just came back to do some updates on some work i did for them a year ago
<7> and it's dead slow
<2> the SP2 "issues" are overrated
<6> *shrug*, I dunno ... I was told "it causes issues" :)
<6> and to disable things ...
<2> lies
<1> it started like a few days ago for me and I cannot seem to narrow it down.. I mean the thing is lagged beyond all belief yet the performance of the system hasn't degraded cpu or memory usage isn't up
<2> just ****ing install it
<6> I am installing it ... haha
<5> zoul: SP2 doesn't enable any of that stuff automatically in a domain environment.
<6> it's downloading the **** now ...
<6> Halo_Four, oh it doesn't ? ... awesome
<5> Not the firewall anyway
<7> things that used to execute in like 10 seconds, views / stored procs and crap, not very optimized though, now just times out :(
<1> yeah
<1> my stored procs are fairly optimized, they used to run in less than second and are timing out
<2> times out even from query analyser?
<2> or just from the app?
<7> both
<5> I would suspect concurrency issues then
<7> in my case :)
<5> QA has no timeout values, it'll sit forever.
<7> actually i did get a deadlock msg today
<1> yeah
<1> mine run fine in QA
<2> are Blackie and BillyB together?
<1> no
<1> separate similar issues
<5> Performance is an art.
<5> Concurrency even moreso
<1> agreed =)
<5> Concurrency is usually the problem. Few solutions are designed with the concept of locking in mind.
<6> Halo_Four performance can't be an art, as art is based on the concept of creativity ... and performance is based on the concept of proper logic
<6> creativity is what makes Windows such a piece of **** ... lol
<1> Halo how can I check for concurrency problems.. just in the locks in process info right?
<5> I am using "art" as a reference to "skill" here.
<5> Blackie: That should show 'em.
<6> Halo_Four, I know ... but I'm waiting for SP2 to download, so i have nothing else better to do but give you **** ... :)
<3> i have got a table with name_id(int) and item_id(int). i want to get all name-id's that are ***ociated with item_id fields containing 5 and 7. is there a way to do that?
<5> zoul: What's not creative about Windows?
<1> I went ahead and backed up the sql server
<6> Halo_Four, nothing ... it's very creative ... and contains no logic ;)
<5> Ron: #mysql
<8> using fts in sql2k can i use CONTAINSTABLE() multiple times to search mutiple tables at once?
<1> err the db that's under the biggest hit that has a 43 meg tran log maybe that makes a difference... I checked locks already but maybe I missed something
<3> Halo_Four: thanks for being helpful
<1> I appreciate your input =P
<2> select name_id from table where item_id in (5, 7);
<7> select distinct name_id from blah where item_id in (5, 7)
<3> hey thanks
<6> Ron, that was as helpful as your gonna get with a mysql question in here
<6> BillyB, we don't support mysql ...
<6> though, I don't recall Ron mentioning mysql ... heh
<2> he did about 10 mins ago :)
<3> well it's the same in mysql i saume, so it's sql
<5> [14:12] <3> #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'kat2 TO kat' at line 1
<2> but I tossed him a bone cause it was too easy
<6> Ron, the reason we don't support mysql is because most things are not the same ...
<5> Not that we "support" any DB.
<3> yes, that was another question and i didn't read the topic, sorry
<8> using fts in sql2k can i use CONTAINSTABLE() multiple times to search mutiple tables at once?
<2> I dont even support my own stuff
<6> Halo_Four, yeah, we support ansi specifications, heh ;)
<3> tnx anyway, i'll try it out
<6> when we feel likeit ...
<6> otherwise, we just talk about how little CoJoNEsX get's laid ...
<2> true :(
<6> every now and again, the topic of how gay I look in a cowboy hat comes up ;)
<2> on average 1x a year
<6> heh
<6> where's Arrakis at, it's time for his daily beating ...
<6> and wow ... I HATE PRIVATE NETWORKS ... so ****ing slow
<1> Halo, do you think this could be file fragmentation issues because of auto-grow? The tempdb has to grow quite a bit each night to accomodate a very intensive dts task. It grows to 2.8 gb. I didn't understand that much about this until recent reading. I restart the sql server by script each morning at 5am, resetting tempdb to 2mb. Then ti has to grow again. Is this my problem?
<6> Blackie, you reset the server every day?
<1> I'm planning on yanking down the server tonight. Setting grow by mb on each db to like 100mb or something. Defrag the file system and see if that helps.
<1> Yeah I'm a retard zoul =) as I realized just about 2 hours ago. I thought it was important to keep the file size low on tempdb because.. I'm a retard.. =)
<1> I mean I read it was important to shrink tempdb or that people did it.. I am doing that also.. the shrink command requires the db service to restart.. maybe this is all wrong?
<1> I'm totally lost this thing was screaming on Friday..
<6> Blackie, restarting the server gets rid of the -in memory- cache the server has ...
<1> right
<6> and that cache is only rebuilt when it's needed, sql server doesnt startup and load crap into memory ... it only keeps in memory whats been asked for, etc... so your performance each morning was due to nothing being in memory at the time
<1> well, I should say my performance each morning wasn't hurt until 2 days ago
<1> but I've been donig this for sometime
<1> dang..
<1> Zoul the majority of the statements are simple select against one normalized data store built overnight
<1> so sql has like a gig of memory in use that ti's not using at all that's why I was restarting it...
<5> Restart of the service is still generally unnecessary. If you want to shrink tempdb you can do so directly.
<1> ok
<1> is there a command that I don't know about? doesn't it require no activity??
<1> Yeah I read about thsi already. I have to start the server in single user mode to get those commands to work, and one of the options requires a restart.. Is there a way to switch to single user mode? Does it carry benefits. I read http://support.microsoft.com/default.aspx/kb/307487
<2> I think you are going about this all wrong
<1> Sigh maybe Cojones.. I'm trying to figure out what is my performance problem
<2> is your slowness due to high cpu load? disk i/o? etc?
<1> not cpu load
<1> disk io maybe but .. I'm not seeing any other services provided by that box effected
<1> and when the report does work it works fast.
<2> so you probably have some data contention
<1> what a second
<2> you need to see what other sessions are doing
<1> err wait
<9> I basically want to duplicate a record in the db
<9> INSERT INTO tablename SELECT * FROM tablename WHERE id = '1'
<9> this isn't working
<9> any help please
Return to
#sql
or
Go to some related
logs:
#gentoo
#computers
#freebsd
#computers
#gentoo
failed with status 195887120
#nhl
#computers
stieve ray vaughan
#windows
|
|