2 Pages12> Go to Page...

Preračun zalog, cen (job) - Preračun zalog,, cen (job) Options

Previous Topic Next Topic

kig		#1 Posted: : 25 March 2015 11:04:48(UTC)
Rank: Advanced Member You have been a member since:: 11/10/2011(UTC) Objave: 75 Thanks: 1 times		Ima še kdo težave pri preračunu zalog, cen na serverju. Zadeva deluje počasi, oz. se ponoči ne izvede.
User Profile View All Posts by User View Thanks

dejan		#2 Posted: : 25 March 2015 11:41:04(UTC)
Rank: PA User You have been a member since:: 24/04/2009(UTC) Objave: 576 Was thanked: 9 time(s) in 9 post(s)		Originally Posted by: kig Ima še kdo težave pri preračunu zalog, cen na serverju. Zadeva deluje počasi, oz. se ponoči ne izvede. Probajte job pognati ročno in boste videli, če je kje težava. Meni se preračun naredi v 5min...
		Vobo d.o.o. Na gorci 66 2000 Maribor www.vobo.si
User Profile View All Posts by User View Thanks

kig		#3 Posted: : 25 March 2015 11:44:36(UTC)
Rank: Advanced Member You have been a member since:: 11/10/2011(UTC) Objave: 75 Thanks: 1 times		Je malo bolj kompleksna zadeva. Na serverju procedura traja 10+ ur Če dam iz programa pa nekje 2 dni
User Profile View All Posts by User View Thanks

dejan		#4 Posted: : 25 March 2015 12:17:27(UTC)
Rank: PA User You have been a member since:: 24/04/2009(UTC) Objave: 576 Was thanked: 9 time(s) in 9 post(s)		Originally Posted by: kig Je malo bolj kompleksna zadeva. Na serverju procedura traja 10+ ur Če dam iz programa pa nekje 2 dni Uh. Kaj te imate bazo 100gb ali kaj ? Mi imamo bazo veliko 7gb(10 let podatkov) in rabi toliko časa kot sem vam napisal.
		Vobo d.o.o. Na gorci 66 2000 Maribor www.vobo.si
User Profile View All Posts by User View Thanks

kig		#5 Posted: : 25 March 2015 12:24:32(UTC)
Rank: Advanced Member You have been a member since:: 11/10/2011(UTC) Objave: 75 Thanks: 1 times		Ravno v tem je problem, ker ne vem kaj ga ubije Baza je slabih 10Gb samo ima ogromno nalogov (DN) Server SQL\*** Job Name preračun Step Name (Job outcome) Duration 16:40:19 Pa se čudi.
User Profile View All Posts by User View Thanks

dejan		#6 Posted: : 25 March 2015 12:25:52(UTC)
Rank: PA User You have been a member since:: 24/04/2009(UTC) Objave: 576 Was thanked: 9 time(s) in 9 post(s)		Originally Posted by: kig Ravno v tem je problem, ker ne vem kaj ga ubije Baza je slabih 10Gb samo ima ogromno nalogov (DN) Server SQL\*** Job Name preračun Step Name (Job outcome) Duration 16:40:19 Pa se čudi. Imam na drugi bazi DN-je velikost 8gb tam rabi 8min :)
		Vobo d.o.o. Na gorci 66 2000 Maribor www.vobo.si
User Profile View All Posts by User View Thanks

kig		#7 Posted: : 25 March 2015 12:45:45(UTC)
Rank: Advanced Member You have been a member since:: 11/10/2011(UTC) Objave: 75 Thanks: 1 times		Originally Posted by: dejan Originally Posted by: kig Ravno v tem je problem, ker ne vem kaj ga ubije Baza je slabih 10Gb samo ima ogromno nalogov (DN) Server SQL\*** Job Name preračun Step Name (Job outcome) Duration 16:40:19 Pa se čudi. Imam na drugi bazi DN-je velikost 8gb tam rabi 8min :) Če ti po 1mb netu pošljem bazo, jo preračunaš v 10 minutah pa vse to ne bo trajalo 16 ur... Tudi na hudem serverju je isto, tako da ni server, ni velikost baze... Podatki ampak kaj?
User Profile View All Posts by User View Thanks

dejan		#8 Posted: : 25 March 2015 12:54:25(UTC)
Rank: PA User You have been a member since:: 24/04/2009(UTC) Objave: 576 Was thanked: 9 time(s) in 9 post(s)		Originally Posted by: kig Originally Posted by: dejan Originally Posted by: kig Ravno v tem je problem, ker ne vem kaj ga ubije Baza je slabih 10Gb samo ima ogromno nalogov (DN) Server SQL\*** Job Name preračun Step Name (Job outcome) Duration 16:40:19 Pa se čudi. Imam na drugi bazi DN-je velikost 8gb tam rabi 8min :) Če ti po 1mb netu pošljem bazo, jo preračunaš v 10 minutah pa vse to ne bo trajalo 16 ur... Tudi na hudem serverju je isto, tako da ni server, ni velikost baze... Podatki ampak kaj? Referenčna integriteta je ok ? So kakšne negativne zaloge ?
		Vobo d.o.o. Na gorci 66 2000 Maribor www.vobo.si
User Profile View All Posts by User View Thanks

sebastijan		#9 Posted: : 26 March 2015 07:29:35(UTC)
Rank: PA User You have been a member since:: 24/04/2009(UTC) Objave: 332		Meni laufa 2 uri.
User Profile View All Posts by User View Thanks

Leon Borko - LAPPS		#10 Posted: : 26 March 2015 14:46:50(UTC)
Rank: Newbie You have been a member since:: 03/05/2013(UTC) Objave: 9		Dobro bi bilo pregledat bazo, če slučajno vsebuje kakšne napake z DBCC. Če teh napak ni je lahko execution plan padel. V teh primeri pomaga samo ponovno kreiranje procedure, ki traja tako dolgo.
		WWW
User Profile View All Posts by User View Thanks

andrejazehelj		#11 Posted: : 26 March 2015 15:15:03(UTC)
Rank: Advanced Member You have been a member since:: 22/09/2012(UTC) Objave: 35		Nam dela preračun zalog celo noč..Katastrofa
		Andreja Žehelj DAVIDOV HRAM D.O.O.
		WWW
User Profile View All Posts by User View Thanks

kig		#12 Posted: : 27 March 2015 08:03:21(UTC)
Rank: Advanced Member You have been a member since:: 11/10/2011(UTC) Objave: 75 Thanks: 1 times		Baza se predno dela backup in preračun naredi -check database integrity -index maintenance -update database statistic to dela nekje 1 uro potem pa no end za preračun
User Profile View All Posts by User View Thanks

Leon Borko - LAPPS		#13 Posted: : 27 March 2015 08:52:48(UTC)
Rank: Newbie You have been a member since:: 03/05/2013(UTC) Objave: 9		Imate mogoče kakšne triggerje na prometih, ki se prožijo ob update zapisa pozicije ali glave dokumenta?
		WWW
User Profile View All Posts by User View Thanks

kig		#14 Posted: : 27 March 2015 08:58:36(UTC)
Rank: Advanced Member You have been a member since:: 11/10/2011(UTC) Objave: 75 Thanks: 1 times		Dodatno ne samo tisti kateri so po "defaultu" v pantheonu
User Profile View All Posts by User View Thanks

Leon Borko - LAPPS		#15 Posted: : 27 March 2015 09:10:32(UTC)
Rank: Newbie You have been a member since:: 03/05/2013(UTC) Objave: 9		Zdaj pa mi je zmanjkalo idej. Lahko se dogovorimo za termin in pregledam, kdo je krivec za tak dolg preračun prometov.
		WWW
User Profile View All Posts by User View Thanks

dejan		#16 Posted: : 30 March 2015 08:48:34(UTC)
Rank: PA User You have been a member since:: 24/04/2009(UTC) Objave: 576 Was thanked: 9 time(s) in 9 post(s)		Kig Na 55.68.10 raje sploh ne probaj delat preračunov :)
		Vobo d.o.o. Na gorci 66 2000 Maribor www.vobo.si
User Profile View All Posts by User View Thanks

kig		#17 Posted: : 30 March 2015 09:04:43(UTC)
Rank: Advanced Member You have been a member since:: 11/10/2011(UTC) Objave: 75 Thanks: 1 times		Super, bom dva dni preračunaval, v ponedeljek delamo, v torek zaprto zaradi preračunov, v sredo delamo, pa še to samo vsako prvo v mesecu, pa v petek če bo vreme pravo :) Sem med vikendom vse izklopil in samo preračun zagnal. Duration 06:17:43 Mi je še v nedeljo ratalo Duration 06:18:48 Zdaj moram do 11h zvečer narediti backupe in ostale zadeve, da bo revež 6ur in pol preračunaval promete!!!!!!
User Profile View All Posts by User View Thanks

MITI_SBR		#18 Posted: : 31 March 2015 09:12:50(UTC)
Rank: Newbie You have been a member since:: 17/03/2014(UTC) Objave: 6		Za kakšno obdobje pa ti preračunava? Ker to je res brutalno dolg čas preračunavanja....
User Profile View All Posts by User View Thanks

MITI_SBR		#19 Posted: : 31 March 2015 09:18:00(UTC)
Rank: Newbie You have been a member since:: 17/03/2014(UTC) Objave: 6		Saj nisi več na SQL2005, ne?
User Profile View All Posts by User View Thanks

kig		#20 Posted: : 31 March 2015 11:35:20(UTC)
Rank: Advanced Member You have been a member since:: 11/10/2011(UTC) Objave: 75 Thanks: 1 times		Po defaultu naj bi preračunaval tekoče leto od zaključka leta naprej.(Materialni prometi) SQL2008
User Profile View All Posts by User View Thanks

Rss Feed  Atom Feed

Users browsing this topic

Guest

2 Pages12> Go to Page...