After it crashed, Windows even cannot be brought up. I have to unplug/replug the wire connected to the hard disk, and then Windows can be started.
I used a software "whocrashed " to diagnose the reason. It suggested I have to update some AMD drivers:
"11 crash dumps have been found and analyzed. 2 third party drivers have been identified to be causing system crashes on your computer. It is strongly suggested that you check for updates for these drivers on their company websites. Click on the links below to search with Google for updates for these drivers:
atikmpag.sys (AMD multi-vendor Miniport Driver, Advanced Micro Devices, Inc.)
atikmdag.sys (ATI Radeon Kernel Mode Driver, ATI Technologies Inc.)"
Is it related to my T-SQL running? Should I set a limit of the memory for database? It seems every crash is related to my job running that consumes very large memory . The total memory is 8GB, and with the run the memory is used 6.5GB.
Thanks!
I used a software "whocrashed " to diagnose the reason. It suggested I have to update some AMD drivers:
"11 crash dumps have been found and analyzed. 2 third party drivers have been identified to be causing system crashes on your computer. It is strongly suggested that you check for updates for these drivers on their company websites. Click on the links below to search with Google for updates for these drivers:
atikmpag.sys (AMD multi-vendor Miniport Driver, Advanced Micro Devices, Inc.)
atikmdag.sys (ATI Radeon Kernel Mode Driver, ATI Technologies Inc.)"
Is it related to my T-SQL running? Should I set a limit of the memory for database? It seems every crash is related to my job running that consumes very large memory . The total memory is 8GB, and with the run the memory is used 6.5GB.
Thanks!
Comment