Ogeysiiska Xogta ah ee Sameecada ee Sameenta Sameeya ee Sameeyaa Xogta Dhex-dhexaadinta Xawaaraha
Agaasimaha SQL Server wuxuu u ogolyahay ogeysiinta tooska ah ee maamulayaasha xogta marka ay dhacaan xaalado aan caadi ahayn. Farsamadan feejignaanta leh waxay awood u leedahay in la kormeero 24-ka saac ee waxqabadka xogta iyada oo aan la shaqeynin xarun hawlgal 24 saac ah.
Shuruudaha Guud ee Qeexidda Feejignaanta
Si loo qeexo digniin, waxaad u baahan tahay macluumaad aasaasi ah oo ay ka mid yihiin:
- Magaca feejignaanta - Magacyada wacyigalinta waa inay ahaataa mid u gaar ah SQL Server. Waxay noqon karaan wax aan ka badnayn 128 xaraf.
- Munaasabadda dhalinta digniinta - Nooca dhacdada ayaa go'aamiya xuduudaha loo isticmaalo. Saddexda nooc ee digniinta ah waa dhacdooyinka SQL Server, xaaladaha hawlgalka SQL Server iyo dhacdooyinka Maareynta Maareynta Maaraynta Windows.
- Ficilka uu wakiilka SQL Server qaato marka dhacdada la kiciyo. Digniin kasta waxaa loo qori karaa midkood (ama labadaba) labada nooc ee digniinta: Ku dhaqan shaqo udub dhexaadiye SQL Server iyo / ama Ogeysii hawlgal.
Tallaabo-tallaabo Adkee Xaqiijinta Adeegyada SQL Server
Tilmaamyadani waxay khuseeyaan SQL Server 2005 iyo kuwa cusub.
- Furan Isticmaalka Isticmaalka Isticmaalka Isticmaalka Naqshadaha ee SQL Server oo ku xidhan server-yada macluumaadka meesha aad rabto inaad abuurto digniin
- Kordhee faylka SQL Server Agent adiga oo gujinaya hal mar ku calaamada " + " ee dhinaca bidixda ee faylka.
- Right-click on Faylka Feejignaanta oo dooro Maqalka Cusub ee menu-pop-up.
- Ku qor magac sharaxaad loogu talagalay heegankaaga sanduuqa qoraalka.
- Dooro nooca heeganka ee liiska hoos u dhaca. Doorashooyinkaaga waa shuruudaha waxqabadka ee SQL Server sida load CPU iyo meelo lacag la'aan ah, dhacdooyinka SQL Server sida qaladaad halis ah, qalada isbarbar dhiga iyo arimaha qalabka, iyo dhacdooyinka Windows Management Instrumentation (WMI).
- Waxaad siisaa faahfaahin kasta oo feejignaan ah oo laga codsado SQL Server sida qoraal gaar ah oo ku jira warbixinta dhacdooyinka iyo xuduudaha digniinta xaaladaha.
- Guji icon Response ee daaqada cusub ee Digniinaha Dooro qaybta bogga .
- Haddii aad rabto in aad fuliso shaqada wakiilka SQL Server marka digniinta dhacdo, riix 'Checkbox' ee shaqada oo aad ka dooratid shaqada aad ka soo degtay.
- Haddii aad rabto inaad u sheegto hawlwadeenada xogta marka ay feejignaadaan dhacaan, riix Sarkaalka Ogeysiinta Daabacaadka ogeysiiska ka dibna ka dooro kuwa ka shaqeeya iyo noocyada wargelinta ee shabakadda.
- Guji OK si aad u abuurto heeganka.
Ku darista Wargalinta Isticmaalka Transact-SQL
Marka laga bilaabo SQL Server 2008, waxaad sidoo kale ku dari kartaa digniinta adeegsiga Transact-SQL. Isticmaal ereygan ka socda Microsoft:
sp_add_alert [@name =] [, [@message_id =] farriinta] [, [@severity =] darnaanta] [, [@enabled =] kartiday] [, [@delay_between_responses =] delay_between_responses] [, [@notification_message =] ' ', [@include_event_description_in =] include_event_description_in] [, [@database_name =]' database ''], [@event_description_keyword =] 'event_description_keyword_pattern'] [, {[@job_id =] job_id | [@job_name =] 'job_name'}] [, [@raise_snmp_trap =] raise_snmp_trap] [, [@performance_condition =] 'performance_condition'] [, [@category_name =] 'category'] [, [@wmi_namespace =] 'wmi_namespace '] [, [@wmi_query =]' wmi_query ']