question

Mohamed4053 avatar image
Mohamed4053 asked

My computer reboots very frequently

Hi All, Today i have intalled windows 7 OS(64 bit) with 2 GB of RAM. After the installation completed i started working. But frequently my system got rebooted with out any errors when i run some T-sql query. I dont know how to resolve this issues. Please guide me. I am guessing, this issue is happen due to inadequate memory. Dont know how to confirm this.
64-bitwindows7issueram
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Are you executing SELECT * FROM VeryLargeData?
1 Like 1 ·
Can you please paste the TSQL query you are running ?
0 Likes 0 ·

1 Answer

· Write an Answer
nidheesh.r.pillai avatar image
nidheesh.r.pillai answered
Hi there, You have menioned the OS, but did not mention the SQL Server version and Edition. For 2012 Microsoft recommends the following- SQL Server 2012 requires a minimum of 6 GB of available hard-disk space. Other requirements are as follows - Memory- Minimum: Express Editions: 512 MB All other editions: 1 GB Recommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance. Processor Speed - Minimum: x86 Processor: 1.0 GHz x64 Processor: 1.4 GHz Recommended: 2.0 GHz or faster
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.