Mu a 1C yadu amfani da namu ci gaban don tsara aikin kamfanin. Musamman, . Baya ga sarrafa takardu (kamar yadda sunan ya nuna), kuma zamani ne - tsarin (Gudanar da abun ciki na Kasuwanci - Gudanar da abun ciki na kamfani) tare da ayyuka masu yawa - wasiku, kalandar aiki na ma'aikata, ƙungiyar raba damar samun albarkatu (misali, ɗakunan taro), bin diddigin lokaci, dandalin kamfanoni da ƙari mai yawa. .
A cikin kamfanin 1C, fiye da ma'aikata dubu suna amfani da sarrafa takardu. Rumbun bayanai ya riga ya girma (bayanin biliyan 11), wanda ke nufin yana buƙatar ƙarin kulawa da ƙarin kayan aiki mai ƙarfi.
Yadda tsarinmu ke aiki, waɗanne matsalolin da muke fuskanta yayin riƙe bayanan da kuma yadda muke magance su (muna amfani da MS SQL Server azaman DBMS) - za mu fada a cikin labarin.
Ga waɗanda suka karanta game da samfuran 1C a karon farko.
1C: Gudanar da Takardu shine mafita na aikace-aikacen (daidaitacce) wanda aka aiwatar akan tsarin haɓaka aikace-aikacen kasuwanci - dandalin 1C: Kasuwanci.
"1C: Document Management 8" (a takaice - DO) ba ka damar sarrafa kansa da aiki tare da takardu a cikin sha'anin. Ɗaya daga cikin manyan kayan aikin sadarwa ga ma'aikata shine imel. Baya ga wasiku, DO kuma yana warware wasu ayyuka:
- Accounting na aiki hours
- Accounting don rashin ma'aikaci
- Aikace-aikace na masu aikawa da sufuri
- Kalanda na aiki na ma'aikata
- Rajista na wasiku
- Lambobin ma'aikata (Littafin adireshi)
- Dandalin kamfanoni
- Ajiye daki
- Shirye-shiryen taron
- CRM
- Aiki tare da fayiloli (tare da adana nau'ikan fayil)
- da sauransu.
Muna zuwa Gudanar da Takardu (aiki na asali) daga Windows, Linux, macOS, (daga browser) da - dangane da halin da ake ciki.
Kuma godiya ga sauran samfuranmu da ke da alaƙa da Gudanar da Takardu - - muna samun aikin manzo kai tsaye a cikin Ayyukan Aiki - taɗi, sauti da kiran bidiyo (ciki har da kiran rukuni, wanda ya zama mahimmanci a yanzu, ciki har da abokin ciniki ta hannu), musayar fayil mai sauri tare da ikon rubuta bots na taɗi wanda ya sauƙaƙa. aiki tare da tsarin. Wani ƙari daga yin amfani da Tsarin Sadarwa (idan aka kwatanta da sauran manzanni) shine ikon gudanar da tattaunawar mahallin da ke da alaƙa da takamaiman abubuwan Gudun Aiki - takardu, abubuwan da suka faru, da sauransu. Wato, Tsarin Sadarwa yana haɗawa sosai tare da aikace-aikacen da aka yi niyya, kuma baya aiki azaman "maɓallin maɓalli".
Yawan haruffa a cikin DO ya riga ya wuce miliyan 100, kuma a gaba ɗaya a cikin DBMS - fiye da bayanan biliyan 11. Gabaɗaya, tsarin yana amfani da kusan TB 30 na ajiya: girman bayanai shine 7,5 TB, fayilolin aikin haɗin gwiwa sun bambanta kuma sun mamaye wani 21 TB.
Idan muka yi magana game da ƙarin takamaiman lambobi, ga adadin haruffa da fayiloli a yanzu:
- Imel masu fita - miliyan 14,7.
- Imel masu shigowa - miliyan 85,4
- Fayil iri-iri - 70,8 miliyan.
- Takardun ciki - 30,6 dubu.
DO yana da fiye da wasiku da fayiloli kawai. A ƙasa akwai lambobin sauran abubuwan lissafin:
- Booking dakunan taro - 52
- Rahotanni na mako-mako - 153
- Rahoton yau da kullun - 628
- Biza ta yarda - 11 821
- Takardu masu shigowa - 79 677
- Takardar bayanan 28
- Shigar da abubuwan da suka faru a kalandar aikin masu amfani - 168
- Aikace-aikace don masu aikawa - 21 883
- Jam'iyyun adawa - 81 029
- Bayanan aiki tare da abokan aiki - 45
- Abokan hulɗa - 41 795
- Abubuwan da suka faru - 10
- Ayyuka - 6 320
- Ayyukan ma'aikata - 245
- Rubutun dandalin - 26
- Saƙonnin taɗi - 891 095
- Hanyoyin kasuwanci - 109. Yin hulɗa tsakanin ma'aikata yana faruwa ta hanyar matakai - yarda, kisa, bita, rajista, sa hannu, da dai sauransu. Muna auna tsawon tafiyar matakai, adadin zagayowar, adadin mahalarta, adadin dawowa, adadin buƙatun canza lokacin ƙarshe. Kuma wannan bayanin yana da matukar amfani don yin nazari don fahimtar irin matakan da ke faruwa a cikin kamfani da kuma inganta ingantaccen aiki tare.
Wane kayan aiki muke sarrafa duk waɗannan akan?
Waɗannan alkalumman suna nuna ayyuka masu ban sha'awa, don haka mun fuskanci buƙatar ware kayan aiki masu inganci don bukatun DO na ciki. Har zuwa yau, halayensa sune kamar haka: 38 cores, 240 GB na RAM, 26 TB na diski. Ga teburin uwar garken:
A nan gaba, muna shirin ƙara ƙarfin kayan aiki.
Yaya sabobin ke lodawa?
Ayyukan hanyar sadarwa bai taɓa zama matsala a gare mu ko ga abokan cinikinmu ba. A matsayinka na mai mulki, mai rauni shine mai sarrafawa da faifai, saboda kowa ya riga ya san yadda za a magance rashin ƙwaƙwalwar ajiya. Anan akwai hotunan sabar mu daga Resource Monitor, wanda ke nuna cewa ba mu da wani mugun nauyi, yana da girman kai.
Misali, a cikin hoton da ke ƙasa muna ganin uwar garken SQL inda CPU ke loda 23%. Kuma wannan alama ce mai kyau (don kwatanta: idan nauyin ya kusan 70%, to, mafi mahimmanci, ma'aikata za su fuskanci raguwa mai mahimmanci).
Hoton hoto na biyu yana nuna uwar garken aikace-aikacen yana gudanar da 1C: dandamalin kasuwanci - yana hidima ne kawai zaman masu amfani. Anan nauyin mai sarrafawa ya dan kadan sama - 38%, yana da santsi da kwanciyar hankali. Akwai loda faifai, amma abin karɓa ne.
Hoton hoto na uku yana nuna wani 1C: uwar garken kamfani (shine na biyu, muna da biyu daga cikinsu a cikin gungu). Wanda ya gabata ne kawai ke hidima ga masu amfani, kuma robots suna aiki akan wannan. Misali, suna karɓar wasiku, takaddun hanya, yin musayar bayanai, ƙidayar haƙƙoƙi, da sauransu. Duk waɗannan ayyukan baya suna gudanar da ayyuka kusan 90-100 na baya. Kuma wannan uwar garken yana lodi sosai - da 88%. Amma wannan ba ya shafar mutane, kuma yana aiwatar da duk aikin sarrafa kansa da ya kamata Gudanar da Takardu ya yi.
Menene ma'auni don auna aiki?
Muna da tsari mai mahimmanci don auna alamun aiki da ƙididdige ma'auni daban-daban a cikin DO ɗinmu. Wannan ya zama dole don fahimtar duka a halin yanzu da kuma hangen nesa na tarihi abin da ke faruwa a cikin tsarin, abin da ke ci gaba da muni, abin da ke samun mafi kyau. Kayan aikin kulawa - ma'auni da ma'aunin lokaci - an haɗa su cikin daidaitaccen isar da "1C: Gudanar da Takardun Takaddun 8". Ma'auni na buƙatar gyare-gyare don aiwatarwa, amma tsarin da kansa ya saba.
Ma'auni sune ma'auni na alamomin kasuwanci daban-daban a wasu wurare cikin lokaci (misali, matsakaicin lokacin isar da saƙo a cikin mintuna 10).
Ɗayan ma'aunin yana nuna adadin masu amfani da ke cikin ma'ajin bayanai. A matsakaici, akwai 1000-1400 daga cikinsu a rana. Jadawalin ya nuna cewa a lokacin hoton hoton, akwai masu amfani da aiki 2144 a cikin bayanan.
Akwai fiye da 30 irin waɗannan ayyuka, jerin suna ƙarƙashin yanke.jerin
- Shiga
- Fita
- Ana loda wasiku
- Canza ingancin abu
- Canza haƙƙin shiga
- Canza batun tsari
- Canja rukunin aiki na abu
- Canza abun da ke ciki na kit
- Canjin fayil
- Shigo da fayil
- Aika ta wasiku
- Matsar da fayiloli
- Juyawa ɗawainiya
- EP sa hannu
- Bincika ta cikakkun bayanai
- Cikakken bincike na rubutu
- Samun fayil
- Katsewar tsari
- Dubawa
- decryption
- Rijistar daftarin aiki
- Duba
- Cire alamar gogewa
- Ƙirƙiri abu
- Ajiye zuwa faifai
- Fara tsari
- Share Shigar Shigar Mai Amfani
- Cire sa hannun ES
- Saita tutar sharewa
- Rufewa
- Babban fayil ɗin fitarwa
Makon da ya gabata, matsakaicin aikin mai amfani da mu ya karu sau ɗaya da rabi (wanda aka nuna a ja akan jadawali) - wannan ya faru ne saboda canjin yawancin ma'aikata zuwa aiki mai nisa (saboda sanannun abubuwan da suka faru). Har ila yau, yawan masu amfani da aiki ya karu da sau 3 (wanda aka nuna a blue akan allon), yayin da ma'aikata suka fara amfani da wayar hannu: kowane abokin ciniki na hannu yana haifar da haɗi zuwa uwar garke. Yanzu, a matsakaita, akwai haɗin kai 2 zuwa uwar garken ga kowane ma'aikatan mu.
A gare mu, a matsayin masu gudanarwa, wannan sigina ce cewa muna bukatar mu mai da hankali ga al'amurran da suka shafi aiki, don ganin ko abubuwa sun yi muni. Kuma muna kallonsa ta wasu hanyoyi. Misali, yadda lokacin isar da saƙon ke canzawa na cikin gida (wanda aka nuna da shuɗi a hoton da ke ƙasa). Za mu iya ganin cewa yana tsalle har zuwa wannan shekara, amma yanzu ya tsaya - a gare mu wannan alama ce cewa duk abin da ke cikin tsari tare da tsarin.
Wani ma'aunin da aka yi amfani da shi a gare mu shine matsakaicin lokacin jira don zazzage haruffa daga sabar saƙon (wanda aka nuna da ja a cikin hoton allo). Kusan magana, har yaushe wasiƙar za ta kewaya Intanet kafin ta isa ga ma'aikacinmu. Hoton hoton ya nuna cewa wannan lokacin bai canza ta kowace hanya kwanan nan ba. Akwai fashe daban-daban - amma ba a haɗa su da jinkiri ba, amma tare da gaskiyar cewa lokaci ya ɓace akan sabar saƙon.
Ko, alal misali, wani ma'auni (wanda aka nuna a cikin shuɗi a cikin hoton allo) - sabunta haruffa a cikin babban fayil. Bude babban fayil ɗin imel aiki ne na gama gari kuma yana buƙatar yin sauri. Muna auna saurin da ake aiwatar da shi. Ana auna wannan alamar don kowane abokin ciniki. Kuna iya ganin duka hoto gaba ɗaya na kamfani da haɓakawa, alal misali, ga ma'aikaci ɗaya. Hoton hoton ya nuna cewa kafin wannan shekara ma'aunin ba shi da daidaituwa, sannan mun yi gyare-gyare da yawa, kuma yanzu ba a kara muni ba - kusan hoto mai faɗi.
Ma'auni shine ainihin kayan aikin mai gudanarwa don sa ido kan tsarin, don saurin amsa duk wani canje-canje a cikin halayen tsarin. Hoton hoton yana nuna awo na DO na ciki na shekara. Tsalle a cikin jadawali saboda gaskiyar cewa an ba mu aikin haɓaka DL na ciki.
Anan akwai jerin ƙarin ma'auni (a ƙarƙashin yanke).
Ma'auni
- Ayyukan mai amfani
- Masu amfani masu aiki
- Ayyuka masu aiki
- Adadin fayiloli
- Girman fayil (MB)
- Adadin takardu
- Adadin abubuwan da za a aika ga masu karɓa
- Adadin abokan tarayya
- Bayanan ayyuka
- Matsakaicin lokacin jira don saukar da saƙonni daga sabar saƙo a cikin mintuna 10 na ƙarshe
- Buffer bayanan waje: adadin fayiloli
- Jinkirin iyaka daga kwanan wata
- dogon layi
- Layin aiki
- Raw asusu ta hanyar turawa waje
- Hanyar Cikin Gida tana karɓar Girman Layi (Dogon layi)
- Hanyar Cikin Gida tana karɓar Girman Layi (Yin sauri da sauri)
- Lokacin isar da saƙo don tuƙi na ciki (dogon layi)
- Lokacin isar da saƙo don tuƙi na ciki (layi sauri)
- Lokacin isar da saƙo ta hanyar turawa waje (matsakaicin)
- Adadin takardun yin rajista
- Adadin takardu Babu
- Yawan takardun "Yi rikodin kan aiki tare da abokin tarayya"
- Saƙonnin sabunta imel a cikin babban fayil
- Wasika Buɗe katin wasiƙa
- Wasika Matsar da saƙo zuwa babban fayil
- Fayilolin kewayawa Mail
Tsarin mu yana ɗaukar ma'auni fiye da 150 a kowane lokaci, amma ba duka ba ne za a iya sa ido a cikin sauri. Za su iya zuwa da amfani daga baya, a cikin wasu hangen nesa na tarihi, kuma za ku iya mayar da hankali kan mafi mahimmanci ga kasuwanci.
A ɗaya daga cikin aiwatarwa, alal misali, alamomi 5 kawai aka zaɓi. Abokin ciniki ya kafa kansa manufar yin ƙaramin saiti na alamomi, amma a lokaci guda irin wannan ya shafi babban yanayin aikin. Ba zai zama ba daidai ba don haɗa alamomin 150 a cikin aikin karɓa, saboda ko da a cikin kasuwancin yana da wahala a yarda da waɗanne alamun da za a yi la'akari da karbuwa. Kuma sun san game da waɗannan alamomin 5 kuma sun riga sun gabatar da su ga tsarin kafin fara aikin aiwatarwa, ciki har da su a cikin takaddun shaida: lokacin buɗe katin ba fiye da 3 seconds, lokacin aiwatar da aiki tare da fayil ba fiye da 5 seconds. da dai sauransu. Muna da ma'auni a cikin DO waɗanda ke nuna a sarari buƙatun farko daga TOR na abokin ciniki.
Kuma muna da nazarin bayanan martaba na ma'aunin aiki. Alamun ayyuka sune ƙayyadaddun tsawon lokacin kowane aiki mai gudana (rubutun wasiƙa zuwa bayanan bayanai, aika wasiƙa zuwa sabar saƙo, da sauransu). Ana amfani da wannan ta musamman ta masu fasaha. Akwai alamun aiki da yawa a cikin shirinmu. Yanzu muna auna kusan ayyukan maɓalli 1500, waɗanda aka karkasu zuwa bayanan martaba.
Ɗaya daga cikin mahimman bayanan martaba a gare mu shine Jerin Ma'aunin Ma'auni na Maɓalli daga Mahimmancin Mabukaci. Wannan bayanin martaba ya ƙunshi, alal misali, alamomi masu zuwa:
- Kisa umarni: Zaɓi ta tag
- Bude form: Form List
- Kisa umarni: Tace ta babban fayil
- Nuna imel a cikin sashin karatu
- Ajiye imel zuwa babban fayil ɗin da kuka fi so
- Nemo haruffa ta cikakkun bayanai
- Rubuta wasiƙa
Idan muka ga cewa ma'auni na wasu alamar kasuwanci ya zama babba (misali, wasiƙu daga wani mai amfani sun fara isowa na dogon lokaci), za mu fara fahimta, juya zuwa auna lokacin ayyukan fasaha. Muna da wani fasaha aiki "Archiving haruffa a kan sabar mail" - mun ga lokacin da ya wuce wannan aiki na karshe lokaci. Wannan aiki, bi da bi, yana lalacewa zuwa wasu ayyuka - alal misali, kafa haɗi zuwa sabar saƙo. Mun ga cewa saboda wasu dalilai ba zato ba tsammani ya zama babba (muna da duk ma'auni na wata daya - zamu iya kwatanta cewa makon da ya gabata ya kasance 10 milliseconds, kuma yanzu shine 1000 milliseconds). Kuma mun fahimci cewa wani abu ya karye a nan - muna buƙatar gyara shi.
Ta yaya za mu kula da irin wannan babban rumbun adana bayanai?
DO na cikin gida misali ne na babban aiki mai ɗaukar nauyi. Bari mu yi magana game da fasaha fasali na database.
Yaya tsawon lokacin da ake ɗauka don sake fasalin manyan tebur ɗin bayanai?
SQL uwar garken yana buƙatar kulawa na lokaci-lokaci, sanya abubuwa cikin tsari a cikin tebur. A hanya mai kyau, wannan ya kamata a yi a kalla sau ɗaya a rana, kuma don tebur da ake buƙata sosai - har ma sau da yawa. Amma idan rumbun adana bayanai yana da girma (kuma adadin bayananmu ya riga ya wuce biliyan 11), to ba shi da sauƙi a kula da shi.
Mun yi wani tebur sake fasalin shekaru 6 da suka gabata, amma sai ya fara ɗaukar lokaci mai yawa har ba mu dace da tazarar dare ba. Kuma tunda waɗannan ayyukan suna ɗaukar nauyin uwar garken SQL, ba zai iya yiwa sauran masu amfani hidima da kyau ba.
Don haka, yanzu dole ne mu yi amfani da dabaru daban-daban. Misali, ba za mu iya aiwatar da waɗannan hanyoyin akan cikakken saitin bayanai ba. Dole ne ku yi amfani da tsarin Layukan Sabuntawa 500000 - wannan yana ɗaukar mintuna 14. Ba ya sabunta ƙididdiga akan duk bayanan da ke cikin tebur, amma yana zaɓar layuka rabin miliyan kuma yana amfani da su don ƙididdige kididdigar da yake amfani da ita ga duka tebur. Wannan wani zato ne, amma an tilasta mana mu yi shi, saboda takamaiman tebur, tattara kididdiga akan duk bayanan biliyan zai ɗauki lokaci mai tsawo wanda ba za a yarda da shi ba.
Mun kuma inganta sauran ayyukan kulawa, mun mai da su bangaranci.
Kula da DBMS gabaɗaya aiki ne mai wahala. A cikin yanayin hulɗar aiki na ma'aikata, bayanan bayanai suna girma da sauri, yana ƙara zama da wuya ga masu gudanarwa su kula da shi - don sabunta ƙididdiga, ɓarna, index. Anan muna buƙatar amfani da dabaru daban-daban, mun san yadda ake yinsa sosai, muna da gogewa, za mu iya raba su.
Ta yaya ake aiwatar da wariyar ajiya tare da irin waɗannan kundin?
Ana yin cikakken madadin DBMS sau ɗaya a rana da daddare, ƙari ɗaya kowace awa. Hakanan ana ƙirƙiri kundin adireshi na fayiloli kowace rana, kuma wani yanki ne na ƙarin ajiyar ajiyar fayil ɗin.
Yaya tsawon lokacin da ake ɗauka don kammala cikakken madadin?
A kan rumbun kwamfutarka, ana yin cikakken madadin a cikin sa'o'i uku, wani bangare na daya a cikin awa daya. Yana ɗaukar lokaci mai tsawo don rubutawa zuwa tef (wani na'ura na musamman da ke yin kwafin ajiya a kan kaset na musamman da aka adana a wajen ofis; ana yin kwafin alienable akan tef ɗin, wanda za a adana shi idan, misali, uwar garken mutum ya ƙone). . Ana yin ajiyar ajiya daidai akan sabar guda ɗaya, sigogin da suka kasance mafi girma - uwar garken SQL tare da nauyin 20% CPU. A lokacin madadin, ba shakka, tsarin ya zama mafi muni, amma har yanzu yana aiki.
Akwai cirewa?
Akwai fayiloli, muna gudanar da shi a kan kanmu, kuma nan ba da jimawa ba zai shigar da sabon sigar Ayyukan Aiki. Har ila yau, muna gwada tsarin cirewa takwarorinsu. Babu kwafin bayanai a matakin DBMS, tunda wannan ba lallai bane. Dandalin 1C: Kasuwanci yana adana abubuwa a cikin DBMS, kuma dandamali ne kawai zai iya ɗaukar nauyin daidaiton su.
Akwai nodes-karanta kawai?
Babu nodes don karantawa (ƙaddamar nodes na tsarin da ke hidima ga waɗanda ke buƙatar karɓar kowane bayanai don karantawa). DO ba tsarin lissafin kuɗi ba ne don sanya kuɗaɗɗen BI daban, amma akwai kuɗaɗe daban don sashen haɓakawa, wanda ake musayar saƙonni a cikin tsarin JSON, kuma lokacin kwafi na yau da kullun shine raka'a da dubun seconds. Kullin har yanzu karami ne, yana da kusan rikodin miliyan 800, amma yana girma cikin sauri.
Kuma ba a goge haruffan da aka yiwa alama don gogewa kwata-kwata?
Tukuna. Ba mu da wani aiki don sauƙaƙe tushe. Akwai lokuta da yawa masu tsanani lokacin da na juya zuwa haruffan da aka yiwa alama don gogewa, gami da 2009. Don haka a yanzu, mun yanke shawarar kiyaye komai. Amma lokacin da farashin wannan ya zama rashin gaskiya, za mu yi tunanin cire shi. Amma, idan kuna buƙatar cire wasu wasiƙar dabam daga bayanan bayanan tare da iyakar don kada a sami alamun, to ana iya yin hakan akan buƙata ta musamman.
Me yasa ake ajiye shi? Akwai kididdigar samun dama ga tsofaffin takardu?
Babu kididdiga. Mafi daidai, yana cikin hanyar yarjejeniya don aikin masu amfani, amma ba a adana shi na dogon lokaci. Ana share bayanan da suka girmi shekara guda daga cikin yarjejeniya.
Akwai yanayi lokacin da ya zama dole a tada tsoffin wasiku na shekaru biyar har ma da shekaru goma da suka gabata. Kuma ana yin hakan koyaushe ba don sha'awar banza ba, amma don yanke shawarwarin kasuwanci masu rikitarwa. Akwai yanayin lokacin da, ba tare da tarihin wasiƙa ba, da an yanke shawarar kasuwanci mara kyau.
Ta yaya ake gudanar da binciken ƙima da lalata takardu bisa ga sharuɗɗan ajiya?
Don takardun takarda, ana yin wannan ta hanyar al'ada ta al'ada, kamar kowa. Ba mu yin shi don na lantarki - bari su ajiye shi don kansu. Zama yana nan. Akwai fa'ida. Kowa yana lafiya.
Menene abubuwan ci gaba?
Yanzu DO ɗinmu yana warware kusan ayyuka 30 na cikin gida, waɗanda muka jera wasu daga cikinsu a farkon labarin. Hakanan ana amfani da DO don shirya tarurrukan da muke gudanarwa sau biyu a shekara don abokan haɗin gwiwarmu: gabaɗayan shirin, duk rahotanni, duk sassan layi ɗaya, zaure - duk waɗannan ana buga su cikin DO, sannan a sauke su, kuma shirin buga shi ne. sanya.
Akwai ƙarin ayyuka da yawa akan hanya don DO, ban da waɗanda ya riga ya warware. Akwai ayyuka na kamfani, kuma akwai ayyuka na musamman da ba safai ba waɗanda wani sashe kawai ke buƙata. Wajibi ne a taimaka musu, wanda ke nufin fadada "geography" na yin amfani da tsarin a cikin 1C - don fadada iyakokin, don magance matsalolin dukkanin sassan. Wannan zai zama mafi kyawun gwaji don aiki da aminci. Ina so in ga tsarin yana aiki akan biliyoyin bayanai, petabytes na bayanai.
source: www.habr.com