Viewing 15 posts - 226 through 240 (of 295 total)
Oh.
In that case, I'm sorry but I have no experience of 64 bit and wouldn;t know if there are any issues or differences with plain old 32 bit.
February 16, 2005 at 8:35 am
Target Server Memory is what SQL wants to use.
Total Server memory is what SQL is actually using.
I can't remember off-hand, but as you must be using AWE then some of...
February 15, 2005 at 3:03 am
The /3GB does not work on Standard
Both SQL and IIS are working with a 2GB address space, even if you have SQL Enterprise. The OS is using the remaining 1Gb.
February 10, 2005 at 5:08 am
If the OS is Advanced Server then you can use the /3GB switch in boot.ini to change the server memory behaviour. There's lots of KB articles on this.
See this one...
February 10, 2005 at 4:39 am
On Win 2003 you do get an warning about the service pack level but not a client error.
It's not a trial verison of Win 2003 or something odd is it?
Or...
February 10, 2005 at 2:01 am
BOL does actually tell you:
...
[ @srvproduct = ] 'product_name'
Is the product name of the OLE DB data source to add as a linked server. product_name is nvarchar(128), with a default...
February 10, 2005 at 1:59 am
Put SQL onto CPU 1?
Is IIS using CPU 0 as well?
Remove the SQL affinity mask and let the OS load balance
Is the database design optimised?
Can you split the roles across...
February 9, 2005 at 2:30 am
As long as teh MDF and LDF files are contiguous, SQL will go somewhat better.
They may not be due to autogrow/autoshrink
February 9, 2005 at 2:25 am
To avoid using system tables use the INFORMATION_SCHEMA objects:
SELECT CATALOG_NAME
FROM INFORMATION_SCHEMA.SCHEMATA
If you need dbid:
SELECT DB_ID(CATALOG_NAME), CATALOG_NAME
FROM INFORMATION_SCHEMA.SCHEMATA
February 8, 2005 at 1:25 am
Given they are usually just a few 10s of MBs, every day is feasible. I do. I also run it manually after any server level changes (new db, new login,...
February 3, 2005 at 4:55 am
I've seen instances where rebuilding the statistics can take some time.
I used to sample 100% during optimisations (to try and head off stats rebuild during working hours) but removed then...
February 2, 2005 at 2:46 am
Once your drive is defragged and you have plenty of growth left in each file (as per last poster) then it shoudldn't need defragged very often to keep the MDF...
January 26, 2005 at 2:19 am
Single XP Pro at home.
No SQL tools and haven't even got Access on.
Used for email, Half-Life 2 and Rise Of Nations. Not work 😎
January 25, 2005 at 2:04 am
I had this a fair while ago now.
It can also happen if the SQL Services are restarted too quickly. I use sysinternals regmon and procexp and saw that that WMI...
January 25, 2005 at 2:01 am
Viewing 15 posts - 226 through 240 (of 295 total)